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

By Bill Graziano on 3 February 2004 | Tags: SQL Server 2005


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.

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


Related Articles

Handling SQL Server Errors (5 April 2010)

Microsoft Releases Updated SQL Server 2005 SP2 (6 March 2007)

SQL Server 2005 SP2 Available (19 February 2007)

SQL Server 2005 Service Pack 2 CTP is Available (8 November 2006)

SQL Server 2005 SP1 (19 April 2006)

SQL Server 2005 RTM Code Available (27 October 2005)

SQL Server 2005 Release Date - November 7th, 2005 (7 June 2005)

April CTP (aka Beta 3) Available Today (18 April 2005)

Other Recent Forum Posts

Checkmark for guaranteed SR = WR (11h)

How to connect to git in SQL Server 2016/2017 without using any third party tool (11h)

Sql restart (16h)

Excel column wise data save in rows (1d)

Date timzone conversion (2d)

Object cannot be cast from DBNULL to other types coming randomly in SSIS Package-Migrated from VS 2008 to 2015,SQL 2008R2 to SQL2016 on 1st run only (2d)

Error in sp procedure- Msg 50000, Level 16, State 1, Procedure spCheckDBInfo, Line 193 [Batch Start Line 0 (2d)

Two records into a single record? (2d)

- Advertisement -