• 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