Inline variable initialization in SQL Server 2008
SQL Server 2008 has introduced Inline variable initialization and composite assignments which allows you to write TSQL statements as above and gives you the power of writing multiple assignment statements in single line of code For example:
