From the course: SQL Server 2014: Developing Databases

Unlock the full course today

Join today to access over 22,400 courses taught by industry experts or purchase this course individually.

Using SQL Server Management Studio

Using SQL Server Management Studio - SQL Server Tutorial

From the course: SQL Server 2014: Developing Databases

Start my 1-month free trial

Using SQL Server Management Studio

- The first tool we're going to take a look at as we develop databases from within SQL Server 2014, is SQL Server Management Studio. Now, that tool is a tool that offers a lot of different features, because it is designed to work with database administrators and database developers. But we're not going to look at the administrative features of SQL Server Management Studio. That is covered in several courses that are offered by lynda.com. Instead we're going to look at the development features. So to do that, let's go ahead and start it. And I'm going to connect into a server that I named SQL2. And we're now connected into SQL Server Management Studio, and what I want to look at is the New Query window, and you can see, she's right up here as usual. In Microsoft tools, there's a number of different ways of starting the tools. But we'll just go with a simple New Query, and allow it to pop up. Now you'll notice when I'm working in the Query Editor here, we have a context database, and if…

Contents