Sql server® 2012 t-sql fundamentals

384  

Microsoft SQL Server 2012 T-SQL Fundamentals

FIGuRE A-9

  The Installation Progress dialog box.

19. 

Click Next to continue. The Complete dialog box appears, as shown in Figure A-10.

FIGuRE A-10

  The Complete dialog box.

This dialog box should indicate the successful completion of the installation. 

20. 

Click Close to finish.

www.it-ebooks.info

---

 

APPENDIX

 

Getting Started

 

 385

Downloading Source Code and Installing the Sample Database

You can find the instructions to download the source code here: http://tsql.solidq.com. In this web-

site, go to the Books section, and select the main page for the book in question. This page has a 

link to download a single compressed file with the book's source code, as well as a script file called 

TSQL2012.sql that creates the sample database. Decompress the files to a local folder (for example, 

C:\TSQLFundamentals).

You will find up to three .sql script files associated with each chapter of the book. One file contains 

the source code for the corresponding chapter and is provided for your convenience, in case you 

don’t want to type the code that appears in the book; this file name matches the title of the corre-

sponding chapter. A second file contains the exercises for the chapter; this file name also matches the 

title of the corresponding chapter but includes the suffix “Exercises.” A third file contains the solutions 

to the chapter’s exercises; this file name matches the title of the corresponding chapter but includes 

the suffix “Solutions.” You use SQL Server Management Studio (SSMS) to open the files and run their 

code. The next section explains how to work with SSMS.

You will also find a text file called orders.txt, for use when practicing the materials from Chapter 8, 

“Data Modification.” Also included is a script file called TSQL2012.sql, which creates the book’s sample 

database, TSQL2012. 

To create the sample database in an on-premises SQL Server instance, you simply need to run this 

script file while you are connected to the target SQL Server instance. If you aren’t familiar with run-

ning script files in SQL Server, you can follow these steps to complete the database creation.