Pro T-SQL 2005 Programmer’s Guide

  • Authors
  • Michael Coles

Table of contents

  1. Front Matter
    Pages i-xxv
  2. Pages 1-13
  3. Pages 15-32
  4. Pages 87-115
  5. Pages 117-142
  6. Pages 143-173
  7. Pages 175-202
  8. Pages 215-226
  9. XML
    Pages 227-272
  10. Pages 273-322
  11. Pages 323-341
  12. Pages 343-377
  13. Pages 379-410
  14. Pages 411-438
  15. Back Matter
    Pages 439-532

About this book

Introduction

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.

Keywords

.NET ADO SQL SQL Server 2000 SQL Server 2005 T-SQL XML XPath XQuery database programming

Bibliographic information