New T-SQL 2008 Syntax

If you are using Microsoft SQL Server 2008 there are some cool new additions to the T-SQL syntax that can help save you a few keystrokes. For example, with T-SQL 2008 you can now (finally) assign a value to a variable when it is declared, like so:

DECLARE @ThisIsLikeSo int = 1984

Rather than having to put the declaration and assignment on two separate lines.

T-SQL 2008 now i...Full Article.