SQL Server
The T-SQL has been enhanced to include error handling, recursive query and to support the new database engine capabilities.
Two new relational operators have been introduced—PIVOT and UNPIVOT for use in the FORM clause query. They perform manipulation on an input table valued expression and output a table as a result.
The APPLY operator allows reference to a table valued function in a correlated sub query.
SQL Server 2005 introduces a simple yet powerful mechanism for exception handling. The TRY/CATCH mechanism is similar to .NET programming languages but is a T-SQL construct that captures errors at a statement level, batch level or transaction to terminate.
DDL enahancements allow users to send notifications to the Service Broker service asynchronously.
Full text search capabilities have been introduced along with cataloging capabilities for greater flexibility. Query performance and scalability have been improved and the new management tools have been provided to ensure full text implementation.
