Pro T-SQL 2005 Programmer’s Guide

• Main Author: Coles, Michael (Author)
• Corporate Author: SpringerLink (Online service)
• Format: Electronic eBook
• Language: English
• Published: Berkeley, CA : Apress, 2007.
• Subjects: Computer science.; Software engineering.; Computer Science.; Software Engineering/Programming and Operating Systems.

Pro T-SQL 2005 Programmer's Guide provides comprehensive and detailed coverage of all the major features and facilities of T-SQL for SQL Server 2005. It is designed for all users of T-SQL, database administrators, systems administrators, application developers, and end-users, who want to learn...

Table of Contents:

• 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.