* 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

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 Presents differences between SQL Server 2000 and version 6.X and 7.0 Includes supplementary material: sn.pub/extras

GPSR Compliance The European Union's (EU) General Product Safety Regulation (GPSR) is a set of rules that requires consumer products to be safe and our obligations to ensure this. If you have any concerns about our products you can contact us on ProductSafety@springernature.com. In case Publisher is established outside the EU, the EU authorized representative is: Springer Nature Customer Service Center GmbH Europaplatz 3 69115 Heidelberg, Germany ProductSafety@springernature.com