Inline Declaration and value assignation in SQL Server 2008

In older environment, we need to declare the variable and set the value for the varaible as below,
 

DECLARE @VAL INT , @VAL1 INT SET @VAL=10 SET @VAL=20

In the newer version of SQL Serve 2008, we are having inline declaration and value assignation.

DECLARE @VAL INT =97, @VAL1 INT =1

Cheers,

Venkatesan Prabu .J
Head - WWW.Kaashivinfotech.com
http://venkattechnicalblog.blogspot.com/