Pro T-SQL 2005 Programmer's Guide (Expert's Voice)

Front Matter....Pages i-xxv The Role of T-SQL....Pages 1-13 Tools of the Trade....Pages 15-32 T-SQL for SQL Server 2000 Programmers....Pages 33-62 Control-of-Flow and CASE Expressions....Pages 63-85 User-Defined Functions....Pages 87-115 Stored Procedures....Pages 117-142 Triggers....Pages 143-173 T-SQL Encryption....Pages 175-202 Error Handling and Debugging....Pages 203-213 Dynamic SQL....Pages 215-226 XML....Pages 227-272 XQuery and XPath....Pages 273-322 SQL Metadata....Pages 323-341 SQLCLR Programming....Pages 343-377 .NET Client Programming....Pages 379-410 HTTP Endpoints....Pages 411-438 Back Matter....Pages 439-532 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. And you'll learn about using locking, isolation levels, and query plans to ensure maximum concurrency and performance. This book is truly a complete programmer's guide to T-SQL and SQL Server 2005.

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.

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. T-SQL is the fundamental language for database programming in SQL Server 2005. All professional SQL Server users 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.