Chapter 3. T-SQL Enhancements

SQL Server 2005 extends the T-SQL language in several significant ways:

• New XML and large object data types

• New and enhanced language capabilities, including support for recursive queries and improved error handling

• Data Definition Language (DDL) triggers

• Catalog views to access metadata

This chapter discusses these enhancements and changes.