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.
Wednesday, May 13, 2009
Declaring a variable in SQL Server 2008
Labels:
DotNetVJ,
Vijaya Kadiyala
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment