Pro T-SQL 2008 Programmer's Guide - Coles, Michael; SpringerLink (Online service) (Berkeley, CA : Apress : Imprint: Apress, 2008)
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.
Keywords: Database management; Microprogramming .; Database Management; Control Structures and Microprogramming