Microsoft SQL Server 2008 T-SQL fundamentals / Itzik Ben-Gan ; project editor, Maria Gargiulo ; technical reviewer, Ron Talmage ; technical review services provided by Content Master, a member of CM Group, Ltd
1. Background to T-SQL Querying and Programming -- 2. Single-Table Queries -- 3. Joins -- 4. Subqueries -- 5. Table Expressions -- 6. Set Operations -- 7. Pivot, Unpivot, and Grouping Sets -- 8. Data Modification -- 9. Transactions and Concurrency -- 10. Programmable Objects -- App. A. Getting Started
Summary
"Master the foundations of T-SQL with the right balance of conceptual and practical content. Get hands-on guidance - including exercises and code samples - that show you how to develop code to query and modify data. You'll gain a solid understanding of the T-SQL language and good programming practices, and learn to write more efficient and powerful queries."--Jacket