SQL SERVER Management Studio

1.? Experimental Purpose

?? Familiar with some operations of SQL SERVER Management Studio

?? Data SQL Server Lite and full database design

2.? experimental content

2.1.? familiarity with the simplified version of SQL Server sample database AdventureWorksLT

2.1.1.? simplified version of the sample database Download

SQL Server sample Database Light-weight LT (simplified version): adventureworkslt2012_database.zip

2.1.2.? Attaching the sample database to the SQL Server DB instance

Main reference steps:

1.? Running SQL Server Management Studio

2.? Additional database: Select MDF file---"add", "Database", "Right-click" menu.

Tips: "Access denied" error when in Windows 7 or Windows 8

WORKAROUND: Run SQL Server Management Studio as Administrator, right-click SQL Server Management studio-Run as Administrator

2.1.3.? View Database Contents

1.? Establishing a AdventureWorks database diagram

The newly attached database needs to be set by the owner to establish the database diagram. The following steps are available for reference:

(1)? Select "Adventureworks2012lt", right-click, select "Properties", select "File" page, click "Owner" button to the right, click "Browse" button, select the currently logged in user or "[SA]".

(2)? Select Database Diagram under ADVENTUREWORKS2012LT, right-click and select New Database diagram.

(3)? Select all the tables in the Pop-up dialog box (SALESLT), click "Add", and click "Close".

The database diagram is set up as follows:

3.? Data Dictionary Description Reference

https://technet.microsoft.com/zh-cn/library/ms124438 (v=sql.100). aspx

SQL SERVER Management Studio