Jiv Studio

Sample Databases for SQL Server

Microsoft provides some sample databases to use to experiment with your code; because you wouldn’t dare query against your live customer data with untested code right?

Samples
http://www.codeplex.com/SqlServerSamples

SQL Server Database Examples
http://www.codeplex.com/SqlServerSamples#databases

I use the Northwind tables from the SQL Server 2000 Sample DBs.

How to Install the Northwind Sample Database

1. Unzip the sample database files you just downloaded
2. Open SQL Server Management Studio (Express if you don’t have the full version) and connect to your SQL Server instance
3. Create a new database called Northwind by right clicking Database and select New Database
4. Go to File/Open, navigate to where you unzipped the download
5. Select instnwnd.sql
6. Click Execute to start the import
7. It will take ~1 minute to complete

Related posts

• My Essential Developer's Toolbox – Part I
• mysqldump Similar Utility for SQL Server

Comments (1)

1. Return Single Value with ExecuteScalar, Stored Procedures and C# | Website Builders Resource says:

   December 3, 2008 at 9:43 pm

   [...] You will need some table data to query against. I am using the Northwind sample database. You can get links to download a copy of the sample database and instructions how to install from here. [...]

   Reply