Install and Attach Northwind Database in SQL Management Studio

In this post I will show How we can download, install NorthWind Database in our SQL Management Studio.

Install and Attach Northwind Database in SQL Management Studio steps :

Step 1 :

Download Northwind database MDF file using this link.

You can also get it from Official mircosoft website.

If you directly want the script file or BAK file,

1. download Northwind database script.
2. Northwind database BAK file

Step 2 : 

Open your SQL Management Studio and select Attach Database option from the menu of the connected server.

Attach Option will Pop-Up. In the Window select the .mdf file of your NorthWind databases files from the folders (Select the location at which you downloaded the MDF file for Northwind database):

C:\SQL Server 2000 Sample Databases

And Click Ok.

NorthWind Database will be attached and restored on your SQL Server. Expand the Databases node on your SQL Management Studio Server node :

Related

Download SQL NorthWind database BAK file

You can download SQL Northwind database bak file using below link or from Github.com. On Github script for the database is present. Official Microsoft site. DOWNLOAD Northwind database BAK file   Northwind is a sample database provided by Mircosoft. It contains sql views, stored procedures along with few tables related to…

May 3, 2020

In "Download"

SQL Server – How to get all Column names of a table

To get Column names of a table in SQL server use query below query: Select COLUMN_NAME,DATA_TYPE from INFORMATION_SCHEMA.COLUMNS where TABLE_NAME='Your_Table_Name' For example: we will consider NorthWind database for querying our SQL column names I want to select all the columns from Categories table, so the query will be: Select COLUMN_NAME,DATA_TYPE…

May 3, 2020

In "SQL"

ASP.NET MVC – How to use JQuery Datatable on Webforms

In this post we will integrate jQuery Datatable on ASP.NET MVC webforms. We will bind a HTML table from SQL data using jQuery. So let's begin. DOWNLOAD SOURCE CODE. I'm using Visual studio 2017 and MS SQL Server 2014 for this example. Features of jQuery Datable: It is a Plugin…

February 26, 2020

In "JQuery"