Pro T-SQL 2008 Programmer’s Guide

  • Authors
  • Michael Coles

Table of contents

  1. Front Matter
    Pages i-xxviii
  2. Pages 61-79
  3. Pages 117-150
  4. Pages 151-185
  5. Pages 187-218
  6. Pages 219-246
  7. XML
    Pages 299-339
  8. Pages 341-386
  9. Pages 407-449
  10. Pages 451-494
  11. Pages 495-523
  12. Pages 525-551
  13. Pages 573-602
  14. Back Matter
    Pages 603-659

About this book


Discussing new and existing features, SQL Server designer and administrator Michael Coles takes you on an expert guided tour of Transact–SQL functionality in SQL Server 2008 in his book, Pro T–SQL 2008 Programmer's Guide. Fully functioning examples and downloadable source code bring Coles' technically accurate and engaging treatment of Transact–SQL into your own hands. Step–by–step explanations ensure clarity, and an advocacy of best–practices will steer you down the road to success.

Pro T–SQL 2008 Programmer's Guide is every developer's key to making full use of SQL Server 2008's powerful, built–in Transact–SQL language. Transact–SQL is the language developers and DBAs use to interact with SQL Server. It's used for everything from querying data, to writing stored procedures, to managing the database. New features in SQL Server 2008 include a spatial data type, SQLCLR integration, the MERGE statement, a dramatically improved and market–leading XML feature set, and support for encryption—all of which are covered in this book


.NET Microsoft SQL Server SQL SQL Server 2000 SQL Server 2008 Transact-SQL database performance

Bibliographic information