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.