Pro T-SQL 2005 Programmer's Guide

Michael Coles has more than a decade's experience designing and administering SQL Server databases. A prolific writer of articles on all aspects of SQL Server, particularly on the expert use of T-SQL, he holds MCDBA and MCP certifications. He graduated magna cum laude with a bachelor of science degree in information technology from American Intercontinental University in Georgia. A member of the United States Army Reserve, he was activated for two years following 9/11.

• The Role of T-SQL.- Tools of the Trade.- T-SQL for SQL Server 2000 Programmers.- Control-of-Flow and CASE Expressions.- User-Defined Functions.- Stored Procedures.- Triggers.- T-SQL Encryption.- Error Handling and Debugging.- Dynamic SQL.- XML.- XQuery and XPath.- SQL Metadata.- SQLCLR Programming.- .NET Client Programming.- HTTP Endpoints.