Advanced Transact-SQL for SQL Server 2000 Softcover reprint of the original 1st ed. - Taschenbuch

This book explores the powerful capabilities of T-SQL and helps you to exploit them to the max. The book tackles advanced areas in T-SQL such as joins, subqueries, stores procedures, triggers, user-defined functions, indexed views, cascading actions, federated views, hierarchial structures and more. The book shows solutions to common problems both in SQL server 2000 and in previous versions. Special emphasis is placed on practicular problems in the industry and on writing efficient and well performing code. The book does not stop at ANSI-92 SQL but also represents features that are particular to SQL Server, especially SQL Server 2000. To help you in your journey, the book provides many puzzles (and beware, these are not simple ones) and proposed solutions.About the authors:Itzik Ben-Gan is a senior SQL Server instructor and consultant with ten years of experience in networking, development, databases and data warehousing. He is a popular columnist and contributing editor for SQL Server Magazine, and is a Microsoft SQL Server MVP.Dr. Tom Moreau is President of Brockman Moreau Consulting, Inc. with more than sixteen years of professional experience in Information Technology. Moreau has been using SQL Server since 1993. He writes regularly for Pinnacle's Microsoft SQL Server Professional newsletter. TOC: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.