Pages

Wednesday, May 13, 2009

Declaring a variable in SQL Server 2008

Previous release of the SQL Server we used to have two lines code to declare a variable and assign a value to that variable.
Ex:
DECLARE @i INT
SET @i = 10000

From 2008 onwards, you can declare and assign a value in single line
Ex:
DECLARE @i INT =10000

This is one of the new feature in SQL Server 2008.

No comments: