|
Pro T-SQL 2005 Programmer's Guide
T-SQL is the fundamental language for database programming in SQL Server 2005. All professional SQL Server users need to know it and, even more important, must understand how to use it well. The language has grown considerably since SQL Server 2000 and even experienced T-SQL programmers have many new features to master. They need a convenient single
source of information and advice. This book provides that, clearly and comprehensively.
Both database administrators and developers will find this highly readable, detailed description of T-SQL an eye-opening and invaluable reference for as long as they work with SQL Server 2005.
Introduction
Chapter 1: The Role of T-SQL
Chapter 2: Tools of the Trade
Chapter 3: Programming Style
Chapter 4: SQL 2005 for SQL 2000 Programmers
Chapter 5: SQL Flow Control/Decision Statements
Chapter 6: User-Defined Functions
Chapter 7: Stored Procedures
Chapter 8: Triggers
Chapter 9: Debugging
Chapter 10: T-SQL Error Handling
Chapter 11: Dynamic SQL
Chapter 12: XML
Chapter 13: System Metadata
Chapter 14: SQLCLR Programming
Chapter 15: .NET Programming
Chapter 16: Performance Enhancement
Appendix A: T-SQL Reserved Words
|
