Table of Contents

		Beginning Transact-SQL with SQL Server 2000 and 2005 byPaul TurleyandDan Wood Wrox Press 2006 (594 pages) ISBN:076457955X Prepare for the ever-increasing demands of programming. Beginning with an overview of the SQL Server query operations and tools used with T-SQL, this authoritative text explains how to design and build applications of increasing complexity.

Table of Contents
	Beginning Transact-SQL with SQL Server 2000 and 2005
	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
	List of Figures
	List of Tables
	List of Try It Outs