New T-SQL Capabilities in SQL Server 2005 - Part 1 of 3

This month I'll start a three-part series on new Transact-SQL language features in SQL Server 2005. Microsoft added many new language features in SQL Server 2005, in response to developer requests and also in following compliance with the SQL-99 standard.