T-SQL Enhancements in SQL Server 2005
In this tutorial you will learn about T-SQL Enhancements in SQL Server 2005 - Data Definition Language Statements, .NET framework integration, Full Text Search, Index transact SQL Statements, Security Transact SQL Enhancements, Service Broker T-SQL statements, Synonym Transact SQL Statements, Table and Index Partitioning Transact SQL Enhancements, Table Transact SQL Enhancements, Triggers and Event Notification Transact SQL Enhancements.
T-SQL enhancements in SQL Server 2005 range from alternative mechanisms for transaction isolation to declarative support for hierarchical queries. The statement level recompilation also improves existing T-SQL applications that were written before 2005. The improvements to Transact SQL can be divided include the following:
Data Definition Language Statements
Data Manipulation Language Statements
Database Console Commands (DBCC) Statements
Metadata
Other Statements
Replication System Stored Procedures
Sample Database Enhancements
Transact-SQL Data Types
Read
More...
http://www.exforsys.com/content/view/1703/356/