The document is archived and information here might be outdated
What's New and Enhanced in Transact-SQL (Transact-SQL)
SQL Server 2005 extends and enhances the Transact-SQL syntax to support new functionality and features.
The enhancements to Transact-SQL that are available in this release of SQL Server are grouped into the following categories:
Other ResourcesWhat's New in SQL Server 2005
SQL Server 2005 Database Engine Backward Compatibility
Help and InformationGetting SQL Server 2005 Assistance