SQLTeam.com Logo

Return to MSDN: Powerful New T-SQL Syntax Gives SQL Server a Programmability Boost

MSDN: Powerful New T-SQL Syntax Gives SQL Server a Programmability Boost

Written by Bill Graziano on 03 February 2004

The T-SQL language in the upcoming version of SQL Server will provide more power and flexibility than previous versions. Additions and enhancements include error handling with the TRY/CATCH construct, SNAPSHOT isolation, and WAITFOR enhancements. Also important are the BULK rowset provider, common table expressions, recursive queries, PIVOT and UNPIVOT operators, and much more. This article introduces these features so readers will be ready for the next version of SQL Server.