Fun with T-SQL
November 15th, 2008
Tweet
As a tribute to some fairly restrictive .NET design I once fell victim to, I wrote this piece of code:
Use [Database]Select [Select]From [From]Where [Where] = ‘Where’And [nvarchar(50)] = ‘nvarchar(50)’And [int] = 1
The CREATE and INSERT statements for the above command:
CREATE TABLE [dbo].[From]([Id] [int] NOT NULL,[Where] [nvarchar](50) NOT NULL,[On] [nvarchar](50) NOT NULL,[Select] [nvarchar](50) NOT NULL,[From] [nvarchar](50) NOT NULL,[int] [int] NOT NULL,[nvarchar(50)] [nvarchar](50) NOT NULL)
INSERT INTO [From] ( [Id], [Where], [On], [Select], [From], [int], [nvarchar(50)])SELECT 1, ‘Where’, ‘On’, ‘:-)’, ‘From’, 1, ‘nvarchar(50)’
Enjoy!
If you enjoyed this post, make sure you subscribe to my RSS feed!
Related posts:
- Ordering Dimensions: Recursion vs Loops in T-SQL
- Moving writeback data in the Fact tables and avoiding problems with changing column names
- Spreading Non-Transactional Data Along Time
Loading ...
