Sql server® 2012 t-sql fundamentals

To create and populate the sample database in an on-premises SQL Server instance

1. 

Double-click the TSQL2012.sql 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 instance you want to connect to appears. 

For example, you would type the name DENALI if your instance was installed as the default 

instance in a computer called DENALI, or DENALI\SQL2012 if your instance was installed as a 

named instance called SQL2012 in a computer called DENALI. 

3. 

In the Authentication box, make sure Windows Authentication is chosen. Click Connect.

4. 

When you are connected to SQL Server, press F5 to run the script. When the execution is 

done, the Command(s) Completed Successfully message should appear in the Messages pane. 

You should see the TSQL2012 database in the Available Databases box.

5. 

When you are done, you can close SSMS.

www.it-ebooks.info

---

386  

Microsoft SQL Server 2012 T-SQL Fundamentals