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

By Bill Graziano on 03 February 2004 | 0 Comments | 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. Follow the link to MSDN: Powerful New T-SQL Syntax Gives SQL Server a Programmability Boost...

Discuss this article: 0 Comments so far. Print this Article. This page has been read 6,586 times.

If you like this article you can sign up for our newsletter. We send it out each week that we post a new article. There's an opt-out link at the bottom of each newsletter so it's easy to unsubscribe at any time.

Email Address:

Email ThisSubscribe to this feedKick itSave to del.icio.usView blog reactions

Related Articles

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)

SQL Server 2005 Developer Webcasts (4 April 2005)

Other Recent Forum Posts

Can SQL Server normalize my tables automatically (0 Replies)

SQL Server Job fails (7 Replies)

Is it this job can program in trigger? (2 Replies)

Failed to import Excel Data (3 Replies)

Cursor issue (2 Replies)

MultiThreading concept in oracle (6 Replies)

MSX & Service Packs (1 Reply)

nothing in tray (4 Replies)

Subscribe to SQLTeam.com

Weekly SQL Server newsletter with articles, forum posts, and blog posts via email:

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

SQL Server Jobs