Hi Everybody,
Northwind database is a free sample database provided by Microsoft and is a really nice practice database. it covers almost all the aspects of sql queries that you may ever encounter.
if you are using sql server 2005 management studio, you dont get Northwind by default.
so here is a quick 4 step guide to install Northwind into SQL server 2005 management studio.
Step 1. Click here to download Northwind.msi.
Step 2. Run and install the downloaded file.
Step 3. The installation will make a C:\SQL Server 2000 Sample Databases folder, open sql server 2005, click on file>>Open>>file>> and point it to a file called instnwnd.sql at the location mentioned above.
Northwind database is a free sample database provided by Microsoft and is a really nice practice database. it covers almost all the aspects of sql queries that you may ever encounter.
if you are using sql server 2005 management studio, you dont get Northwind by default.
so here is a quick 4 step guide to install Northwind into SQL server 2005 management studio.
Step 1. Click here to download Northwind.msi.
Step 2. Run and install the downloaded file.
Step 3. The installation will make a C:\SQL Server 2000 Sample Databases folder, open sql server 2005, click on file>>Open>>file>> and point it to a file called instnwnd.sql at the location mentioned above.
Step 4. It will open a huge query file in the sql server, now just press f5 to execute this and the northwind database will be ready in your object explorer.
Happy practicing !!!
EXCELLENT ! THANK YOU VERY MUCH
ReplyDeleteThank you !!
ReplyDelete