Advertisement

Pro T-SQL Programmer's Guide

  • Authors
  • Miguel Cebollero
  • Jay Natarajan
  • Michael Coles

Table of contents

  1. Front Matter
    Pages i-xxxiv
  2. Miguel Cebollero, Jay Natarajan, Michael Coles
    Pages 1-18
  3. Miguel Cebollero, Jay Natarajan, Michael Coles
    Pages 19-46
  4. Miguel Cebollero, Jay Natarajan, Michael Coles
    Pages 47-77
  5. Miguel Cebollero, Jay Natarajan, Michael Coles
    Pages 79-110
  6. Miguel Cebollero, Jay Natarajan, Michael Coles
    Pages 111-151
  7. Miguel Cebollero, Jay Natarajan, Michael Coles
    Pages 153-176
  8. Miguel Cebollero, Jay Natarajan, Michael Coles
    Pages 177-205
  9. Miguel Cebollero, Jay Natarajan, Michael Coles
    Pages 207-232
  10. Miguel Cebollero, Jay Natarajan, Michael Coles
    Pages 233-268
  11. Miguel Cebollero, Jay Natarajan, Michael Coles
    Pages 269-315
  12. Miguel Cebollero, Jay Natarajan, Michael Coles
    Pages 317-345
  13. XML
    Miguel Cebollero, Jay Natarajan, Michael Coles
    Pages 347-385
  14. Miguel Cebollero, Jay Natarajan, Michael Coles
    Pages 387-431
  15. Miguel Cebollero, Jay Natarajan, Michael Coles
    Pages 433-460
  16. Miguel Cebollero, Jay Natarajan, Michael Coles
    Pages 461-510
  17. Miguel Cebollero, Jay Natarajan, Michael Coles
    Pages 511-557
  18. Miguel Cebollero, Jay Natarajan, Michael Coles
    Pages 559-587
  19. Miguel Cebollero, Jay Natarajan, Michael Coles
    Pages 589-612
  20. Miguel Cebollero, Jay Natarajan, Michael Coles
    Pages 613-651
  21. Miguel Cebollero, Jay Natarajan, Michael Coles
    Pages 653-662
  22. Miguel Cebollero, Jay Natarajan, Michael Coles
    Pages 663-668
  23. Miguel Cebollero, Jay Natarajan, Michael Coles
    Pages 669-681
  24. Miguel Cebollero, Jay Natarajan, Michael Coles
    Pages 683-691
  25. Back Matter
    Pages 693-707

About this book

Introduction

Pro T–SQL Programmer’s Guide is your guide to making the best use of the powerful, Transact-SQL programming language that is built into Microsoft SQL Server's database engine. This edition is updated to cover the new, in-memory features that are part of SQL Server 2014. 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. Support for in-memory stored procedures running queries against in-memory tables is new in the language and gets coverage in this edition. Also covered are must-know features such as window functions and data paging that help in writing fast-performing database queries. Developers and DBAs alike can benefit from the expressive power of T-SQL, and Pro T-SQL Programmer's Guide is your roadmap to success in applying this increasingly important database language to everyday business and technical tasks.

  • Covers the newly-introduced, in-memory database features
  • Shares the best practices used by experienced professionals
  • Goes deeply into the subject matter − an advanced book for the serious reader

Bibliographic information

Industry Sectors
Pharma
Chemical Manufacturing
Biotechnology
Finance, Business & Banking
Electronics
IT & Software
Telecommunications
Consumer Packaged Goods
Energy, Utilities & Environment
Engineering