2008-11-15

Fun with T-SQL

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!

0 comments: