Advanced Transact-SQL for SQL Server 2000 (Apress)
By: Itzik Ben-Gan, Tom Moreau
Published: Oct 2000
ISBN: 1893115828
814 printed pages.
In "Advanced Transact-SQL for SQL Server 2000," Tom and I explore the power capabilities of Transact-SQL. The book offers 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 database programmers to write more efficient and better-performing code that takes full advantage of Transact-SQL. The book offers practical solutions to the everyday problems programmers face and provide significant content on the advanced areas in T-SQL such as joins, subqueries, stored procedures, triggers, user-defined functions (UDFs), indexed views, cascading actions, federated views, hierarchical structures, cursors and more.

• Table of Contents

• Detailed TOC

• Source Code

• Corrections (for first print; fixed in current print)

• Sample Chapters

You can purchase the book in all major internet stores.