Includes bibliographical references (pages 795-798) and index.
Joins in T-SQL -- Subqueries and derived tables -- Populating tables -- Other data manipulation issues -- Summarizing data -- Special datatypes and properties -- Writing code in T-SQL -- Views -- Stored procedures -- Triggers -- User-defined functions -- Working with temporary tables -- Horizontally partitioned views -- Implementing cascading operations -- Working with cursors -- Expanding hierarchies -- Tips & Tricks.
0
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.
Master and use copy. Digital master created according to Benchmark for Faithful Digital Reproductions of Monographs and Serials, Version 1. Digital Library Federation, December 2002.