SQL SERVER 2005 includes new Transact-SQL (T-SQL) functionality. SQL Server 2005 represents a major enhancement to SQL Server. Even if you ignore major additions such as hosting the CLR, Common Language Runtime, in process in SQL Server and support of XML as a first-class native data type, the T-SQL enhancements alone are enough to consider this a major update of SQL Server.
The enhancements span the range from more support of SQL:1999 syntax for SQL to enhanced error handling.
In brief, the improvements include the following:
• Error handling—
CATCH syntax for handling errors
TOP—Row count based on an expression
ON DELETE and