Sql server® 2012 t-sql fundamentals

To create and populate the sample database in SQL database

1. 

Double-click the file name in Windows Explorer to open the file in SSMS. The Connect To 

Database Engine dialog box appears.

2. 

In the Server Name box, ensure that the name of the SQL Database server you want to con-

nect to appears—for example, myserver.database.windows.net. 

3. 

In the Authentication box, make sure SQL Authentication is chosen and the correct logon 

name and password are entered. Click Options.

4. 

On the Connection Properties tab, type master in the Connect To Database text box, and 

then click Connect.

5. 

Skip the instructions under Section A in the script (for an on-premises SQL Server instance) 

and follow the instructions under Section B in the script (for SQL Database). The most impor-

tant instruction is the one telling you to run the following command to create the TSQL2012 

database.

CREATE DATABASE TSQL2012;

6. 

Right-click any empty area in the query pane and choose Connection | Change Connection. 

The Connect To Database Engine dialog box appears. Specify TSQL2012 as the database to 

connect to, and click Connect. You should see the TSQL2012 database in the Available Data-

bases box.

As an alternative, you can simply select the TSQL2012 database from the Available Data-

bases box.

7. 

  Highlight the code in Section C (beginning with Create Schemas and all the way to the end of 

the script file). Press F5 to run the script. When the execution is done, the Command(s) Com-

pleted Successfully message should appear in the Messages pane. Note that on slow connec-

tions it might take the code a few minutes to complete.

8. 

When you are done, you can close SSMS.

The data model of the TSQL2012 database is provided in Figure A-11 for your convenience.

www.it-ebooks.info

---