Northwind and pubs sample databases for Microsoft SQL Server

Northwind  Database 인데 오리지널 버전은 SQL Server 2000 으로 만들어졌었지만 

최근 MS Server 에서도 파일을 집적 복붙하여 사용가능하다

instnwnd.sql 파일

 

생성하고 나면 웹사이트 같은 느낌이라 테스트해보기에 좋다 

고개 정보, 주문, 제품, 지역, 직원 등등의 정보들이 있다

 

Northwind and pubs sample databases for Microsoft SQL Server

This folder contains scripts to create and load the Northwind (instnwnd.sql) and pubs (instpubs.sql) sample databases.

These scripts were originally created for SQL Server 2000.

 

 

Before you begin

To run this sample, you need a tool that can run Transact-SQL scripts. You can run the scripts in the following tools:

• SQL Server Management Studio (SSMS). To download SSMS, go to Download SQL Server Management Studio (SSMS).
• SQL Server Data Tools (SSDT) or Visual Studio. To download SSDT, or to enable its features in Visual Studio, go to Download and install SQL Server Data Tools (SSDT) for Visual Studio.

Run the scripts in SSMS

 

 

https://github.com/microsoft/sql-server-samples/tree/master/samples/databases/northwind-pubs

GitHub - microsoft/sql-server-samples: Azure Data SQL Samples - Official Microsoft GitHub Repository containing code samples for

https://raw.githubusercontent.com/microsoft/sql-server-samples/master/samples/databases/northwind-pubs/instnwnd.sql