The Role of T-SQL.- Tools of the Trade.- T-SQL for SQL Server 2000 Programmers.- Expand coverage, add new statements like MERGE.- New data types: Spatial data, vardecimal, etc.- Control-of-Flow and CASE Expressions.- User-Defined Functions.- Expand coverage, table parameters, etc.- Stored Procedures.- Expand coverage, table parameters, etc.- Parameter sniffing.- Triggers.- Expand coverage.- T-SQL Encryption.- Expand coverage, include new encryption functions.- Expand discussion of SQLCLR encryption.- Error Handling and Debugging.- Dynamic SQL.- XML.- XQuery and XPath.- Expanded discussion of XQuery and XPath.- SQL Metadata.- Additional catalog view information.- Additional coverage of system functions.- SQLCLR Programming.- .NET Client Programming.- HTTP Endpoints.- Cursors * new *.- Full-Text Search * new *.- Query Optimization and Performance Enhancement * new *.- SQL Keywords.- XQuery Data Types.- XQuery Terms.- Selected T-SQL Source Code Listings.- .NET Source Code Listings.
