Advanced Transact-SQL for SQL Server 2000

  • 10h 55m
  • Itzik Ben-Gan, Tom Moreau, Ph.D.
  • Apress
  • 2000

In Advanced Transact-SQL for SQL Server 2000, Itzik Ben-Gan and Thomas Moreau explore the power capabilities of Transact-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 Transact-SQL. The authors offer 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. - Provides hundreds of solutions to common problems encountered by SQL Server programmers. - Both authors write regularly for SQL Server Magazine and Pinnacle Publishing's Microsoft SQL Server Professional newsletter. - Includes expert tips and plenty of real code examples.

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. He has been programming since 1971 and has over 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.

In this Book

  • Joins in T-SQL
  • Subqueries and Derived Tables
  • Populating Tables
  • Other Data Manipulation Issues
  • Summarizing Data
  • Special Datatypes and Properties
  • Writing Code in Transact-SQL
  • Views
  • Stored Procedures
  • Triggers—the Hidden Stored Procedures
  • User-Defined Functions
  • Temporary Tables
  • Horizontally Partitioned Views
  • Implementing Referential Integrity and Cascading Actions
  • Server-Side Cursors—the SQL of Last Resort
  • Expanding Hierarchies
  • Tips and Tricks
  • SQL Puzzle Solutions