Beginning T-SQL with Microsoft SQL Server 2005 and 2008

This zip file contains SQL script examples from the book. These include selections of queries from the chapters covering the foundational T-SQL concepts, specifically chapters 4-11. Some queries are not included intentionally--for example, if they could result in global modifications to the databases.

Script files are also included for the exercises in the book, specifically for chapters 3, 5, 6, 7, 8, 9, 10, 11, 12, 13 and 14. The remaining chapters do not have associated code files.

To follow the examples in this book, you will need to have SQL Server 2005 or 2008 installed. You’ll need a machine that can support the minimum hardware requirements to run the appropriate verison of SQL Server. 

For the downloaded exercise scripts and the examples throughout this book, use the following sample databases, which are available to download from Microsoft: the sample database for SQL Server 2005 is called AdventureWorks, and the sample database for SQL Server 2008 is called AdventureWorks2008. Because the structure of these databases differs significantly, separate code samples are provided throughout the book for these two version-specific databases. An example using the AdventureWorks2008DW database for SQL Server 2008 is also used in Chapter 15. To download and install these sample databases, browse www.codeplex.com. This site is managed by Microsoft.

For SQL Server 2008, you’ll want to have the databases from the SQL2008.AdventureWorks_OLTP_DB_v2008.zip and SQL2008.AdventureWorks_DW_BI_v2008.zip files installed. These databases are not installed with SQL Server 2008 by default and must be downloaded from either www.codeplex.com or from www.wrox.com/go/SQLServer2008RTMDataSets.