Pro T-SQL 2012 Programmer’s Guide

  • Authors
  • Jay Natarajan
  • Rudi Bruchez
  • Scott Shaw
  • Michael Coles

Table of contents

  1. Front Matter
    Pages i-xxxiv
  2. Jay Natarajan, Rudi Bruchez, Scott Shaw, Michael Coles
    Pages 1-17
  3. Jay Natarajan, Rudi Bruchez, Scott Shaw, Michael Coles
    Pages 19-45
  4. Jay Natarajan, Rudi Bruchez, Scott Shaw, Michael Coles
    Pages 47-77
  5. Jay Natarajan, Rudi Bruchez, Scott Shaw, Michael Coles
    Pages 79-109
  6. Jay Natarajan, Rudi Bruchez, Scott Shaw, Michael Coles
    Pages 111-149
  7. Jay Natarajan, Rudi Bruchez, Scott Shaw, Michael Coles
    Pages 151-178
  8. Jay Natarajan, Rudi Bruchez, Scott Shaw, Michael Coles
    Pages 179-203
  9. Jay Natarajan, Rudi Bruchez, Scott Shaw, Michael Coles
    Pages 205-237
  10. Jay Natarajan, Rudi Bruchez, Scott Shaw, Michael Coles
    Pages 239-286
  11. Jay Natarajan, Rudi Bruchez, Scott Shaw, Michael Coles
    Pages 287-315
  12. XML
    Jay Natarajan, Rudi Bruchez, Scott Shaw, Michael Coles
    Pages 317-354
  13. Jay Natarajan, Rudi Bruchez, Scott Shaw, Michael Coles
    Pages 355-398
  14. Jay Natarajan, Rudi Bruchez, Scott Shaw, Michael Coles
    Pages 399-424
  15. Jay Natarajan, Rudi Bruchez, Scott Shaw, Michael Coles
    Pages 425-467
  16. Jay Natarajan, Rudi Bruchez, Scott Shaw, Michael Coles
    Pages 469-515
  17. Jay Natarajan, Rudi Bruchez, Scott Shaw, Michael Coles
    Pages 517-544
  18. Jay Natarajan, Rudi Bruchez, Scott Shaw, Michael Coles
    Pages 545-566
  19. Jay Natarajan, Rudi Bruchez, Scott Shaw, Michael Coles
    Pages 567-606
  20. Back Matter
    Pages 607-659

About this book

Introduction

Pro T–SQL 2012 Programmer’s Guide is every developer’s key to making full use of SQL Server 2012’s powerful, built–in Transact–SQL language. Discussing new and existing features, the book takes you on an expert guided tour of Transact–SQL functionality. Fully functioning examples and downloadable source code bring 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.

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 T-SQL 2012 include full support for window functions, stored sequences, the ability to throw errors, data paging, and more. All these important new features are covered in this book. Developers and DBAs alike can benefit from the expressive power of Transact-SQL, and Pro T-SQL 2012 Programmer's Guide provides the gateway to success in applying this increasingly important database language to everyday business and technical tasks.

Bibliographic information