Foreword.

Chapter 1: Introducing Transact-SQL and Data Management Systems.

Chapter 2: SQL Server Fundamentals.

Chapter 3: Tools for Accessing SQL Server.

Chapter 4: Introducing Transact-SQL Language.

Chapter 5: Data Retrieval.

Chapter 6: SQL Functions.

Chapter 7: Aggregation and Grouping.

Chapter 8: Multi-Table Queries.

Chapter 9: Data Transactions.

Chapter 10: Advanced Queries and Scripting.

Chapter 11: Full-Text Index Queries.

Chapter 12: Creating and Managing Database Objects.

Chapter 13: Transact-SQL Programming Objects.

Chapter 14: Transact-SQL in Applications and Reporting.

Appendix A: Command Syntax Reference.

Appendix B: System Variables and Functions Reference.

Appendix C: System Stored Procedure Reference.

Appendix D: Information Schema Views Reference.

Appendix E: Answers to Exercises.

Index.