Advanced Transact-SQL for SQL Server 2000

✍ Scribed by Itzik Ben-Gan, Tom Moreau Ph.D. (auth.)

• Publisher: Apress
• Year: 2000
• Tongue: English
• Leaves: 841
• Edition: 1
• Category: Library

✦ Synopsis

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.

✦ Table of Contents

Front Matter....Pages i-xlii
Joins in T-SQL....Pages 1-42
Subqueries and Derived Tables....Pages 43-79
Populating Tables....Pages 81-109
Other Data Manipulation Issues....Pages 111-159
Summarizing Data....Pages 161-196
Special Datatypes and Properties....Pages 197-232
Writing Code in Transact-SQL....Pages 233-259
Views....Pages 261-301
Stored Procedures....Pages 303-340
Triggers-the Hidden Stored Procedures....Pages 341-373
User-Defined Functions....Pages 375-433
Temporary Tables....Pages 435-458
Horizontally Partitioned Views....Pages 459-501
Implementing Referential Integrity and Cascading Actions....Pages 503-552
Server-Side Cursors — the SQL of Last Resort....Pages 553-577
Expanding Hierarchies....Pages 579-627
Tips and Tricks....Pages 629-670
SQL Puzzle Solutions....Pages 671-733
Back Matter....Pages 735-816

✦ Subjects

Software Engineering/Programming and Operating Systems