|
Advanced Transact-SQL for SQL Server 2000
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.
* 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
* Provides hundreds of solutions to common problems encountered by SQL Server programmers
* Foreword
* About the Authors
* Preface
* Introduction
* Chapter 1: Joins in T-SQL
* Chapter 2: Subqueries and Derived Tables
* Chapter 3: Populating Tables
* Chapter 4: Other Data Manipulation Issues
* Chapter 5: Summarizing Data
* Chapter 6: Special Datatypes and Properties
* Chapter 7: Writing Code in T-SQL
* Chapter 8: Views
* Chapter 9: Stored Procedures
* Chapter 10: Triggers -- The Hidden Stored Procedures
* Chapter 11: User-Defined Functions
* Chapter 12: Temporary Tables
* Chapter 13: Horizontally Partitioned Views
* Chapter 14: Implementing Referential Integrity and Cascading Actions
* Chapter 15: Server-Side Cursors -- the SQL of Last Resort
* Chapter 16: Expanding Hierarchies
* Chapter 17: Tips and Tricks
* Chapter 18: SQL Puzzle Solutions
* Appendix A: DML Basics
* Appendix B: Checking for ANSI Compatibility with SET FIPS_FLAGGER
* Appendix C: Analyzing Query Performance
* Appendix D: Ownership Chains
* Appendix E: Pubs and Northwind Database Schemas
* Appendix F: Dynamically Creating Triggers for Cascade Actions
* Appendix G: References
* Index
|
