Pro T-SQL 2005 Programmer's Guide

Description

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 how to exploit the power of T-SQL. Whatever you need to do with T-SQL, you'll find it described clearly here.

Stored procedures, triggers, and user-defined functions are only part of the story. Dynamic SQL, the new XML data type, and SQLCLR programming are also covered, as well as accessing SQL Server with ADO.NET. Exception handling and performance are fully covered, too. This book is truly a complete programmer's guide to T-SQL and SQL Server 2005.

CONTENTS:

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