This book provides you with a comprehensive introduction to the T-SQL language and shows you how it can be used to work with both the SQL Server 2000 and 2005 releases.

    Beginning with an overview of the SQL Server query operations and tools that are used with T-SQL the author goes on to explain how to design and build applications of increasing complexity.

    By gaining an understanding of the power of the T-SQL language, you'll be prepared to meet the ever-increasing demands of programming.

Chapter 1: Introducing Transact-SQL and Data Management
Systems
Chapter 2: SQL Server Fundamentals
Chapter 3: Tools for Accessing SQL Language
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

Etc.