Code Centric: T-SQL Programming with Stored Procedures and Triggers

  • Garth Wells

Table of contents

  1. Front Matter
    Pages i-xxiii
  2. Transact-SQL Basics

    1. Front Matter
      Pages 1-1
    2. Garth Wells
      Pages 3-18
    3. Garth Wells
      Pages 19-34
    4. Garth Wells
      Pages 35-70
    5. Garth Wells
      Pages 71-131
    6. Garth Wells
      Pages 149-191
    7. Garth Wells
      Pages 193-212
    8. Garth Wells
      Pages 213-238
  3. Procedures and Triggers

    1. Front Matter
      Pages 239-239
    2. Garth Wells
      Pages 241-292
    3. Garth Wells
      Pages 293-315
    4. Garth Wells
      Pages 317-382
    5. Garth Wells
      Pages 383-406
  4. Putting SQL to Work

    1. Front Matter
      Pages 407-407
    2. Garth Wells
      Pages 409-485
    3. Garth Wells
      Pages 487-529
  5. Back Matter
    Pages 531-695

About this book


If you want to learn how to write stored procedures and triggers for Microsoft SQL Server, Code Centric: T-SQL Programming with Stored Procedures and Triggers is the book for you. Youll learn real-world coding and how to build non-trivial applications. All of the examples covered in the book are available for download, making it easier to work through over 5,000 lines of sample code.

While there is extensive coverage of the new functionality in SQL Server 2000—such as UDFs (user-defined functions)—you can use this book effectively for virtually any version of SQL Server6.x, 7.0, or 2000.


Extensible Markup Language (XML) Microsoft SQL Server SQL SQL programming T-SQL Transact-SQL XML databases design development language optimization programming structured analysis testing

Authors and affiliations

  • Garth Wells
    • 1
  1., Inc.USA

Bibliographic information