From the course: SQL Server 2016: Administer a Database Infrastructure

Use the exercise files - SQL Server Tutorial

From the course: SQL Server 2016: Administer a Database Infrastructure

Start my 1-month free trial

Use the exercise files

“

- [Instructor] If you have access to the Exercise Files for this course, then you're going to be able to follow along with the actions that I'm performing here on the screen. Simply download and extract them to a location on your computer that's convenient to get to. I've gone ahead and placed mine here on the desktop. Inside of the Exercise Files folder is a folder for each chapter of the course. And inside each chapter folder are the individual SQL files that we'll be running. These are just plain text files that you can open up inside of Notepad. Or if you double-click on them, they should open up in SQL Server Management Studio. Inside of these scripts when we're ready to run a command, make sure you highlight the text that you want to run before pressing the Execute button or pressing the F5 shortcut key. That'll ensure that we run just the highlighted lines and not the entire file all at once. At the end of each file are usually a couple of lines that'll reset the server back to the state that it was in when we started the exercise. Now, there's one small change that I want to make to the default interface so that it's easier to follow along with what I'm doing here on the screen. Let's go ahead and add in some line numbers onto our files by going up to the Tools menu, coming down to Options, and then going into the Text Editor options, and then finally clicking on Transact SQL. Here, I'll place a check mark in the option to enable line numbers and press the OK button. And when we come back to our file, you'll notice that we have line numbers now in the left side of the screen. Now, if you don't have access to the Exercise Files, that's okay. You can copy down the code that you see here on the screen, follow along with your own databases, or simply sit back and watch.

Contents