Advertisement

Advanced Transact-SQL for SQL Server 2000

  • Authors
  • Itzik Ben-Gan
  • Tom Moreau

Table of contents

  1. Front Matter
    Pages i-xlii
  2. Itzik Ben-Gan, Tom Moreau
    Pages 1-42
  3. Itzik Ben-Gan, Tom Moreau
    Pages 43-79
  4. Itzik Ben-Gan, Tom Moreau
    Pages 81-109
  5. Itzik Ben-Gan, Tom Moreau
    Pages 111-159
  6. Itzik Ben-Gan, Tom Moreau
    Pages 161-196
  7. Itzik Ben-Gan, Tom Moreau
    Pages 197-232
  8. Itzik Ben-Gan, Tom Moreau
    Pages 233-259
  9. Itzik Ben-Gan, Tom Moreau
    Pages 261-301
  10. Itzik Ben-Gan, Tom Moreau
    Pages 303-340
  11. Itzik Ben-Gan, Tom Moreau
    Pages 341-373
  12. Itzik Ben-Gan, Tom Moreau
    Pages 375-433
  13. Itzik Ben-Gan, Tom Moreau
    Pages 435-458
  14. Itzik Ben-Gan, Tom Moreau
    Pages 459-501
  15. Itzik Ben-Gan, Tom Moreau
    Pages 503-552
  16. Itzik Ben-Gan, Tom Moreau
    Pages 553-577
  17. Itzik Ben-Gan, Tom Moreau
    Pages 579-627
  18. Itzik Ben-Gan, Tom Moreau
    Pages 629-670
  19. Itzik Ben-Gan, Tom Moreau
    Pages 671-733
  20. Back Matter
    Pages 735-816

About this book

Introduction

In Advanced Transact-SQL for SQL Server 2000, authors Itzik Ben-Gan and Thomas Moreau explore the powerful capabilities of Transact-SQL (T-SQL). Ben-Gan and Moreau offer solutions to common problems encountered using all versions of SQL Server, with a focus on the latest version, SQL Server 2000.

Expert tips and real code examples teach advanced database programmers to write more efficient and better-performing code that takes full advantage of T-SQL. The authors offer practical solutions to the everyday problems programmers face and include in-depth information on advanced T-SQL topics such as joins, subqueries, stored procedures, triggers, user-defined functions (UDFs), indexed views, cascading actions, federated views, hierarchical structures, cursors, and more.

Keywords

LA Microsoft SQL Server Programmieren SQL SQL Server 2000 T-SQL T-SQL Entwicklung Transact-SQL logic

Bibliographic information