Tag Archives: NTEXT

Declaring and Initializing variables in one statement : SQL Server 2008 T-SQL Enhancements

In SQL Server 2008 onwards, the DECLARE statement has been enhanced to support the declaration and initialization of variables in one statement. Now we can initialize values for most data types. The following code example shows how to declare and initialize a variable. declare @test_var int =10 print @test_var In the above example, we have [...]