-
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
