Advanced Transact-SQL for SQL Server 2000

Description

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. 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