From the course: Microsoft SQL Server 2019 Essential Training

Unlock the full course today

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

Install Management Studio

Install Management Studio - SQL Server Tutorial

From the course: Microsoft SQL Server 2019 Essential Training

Start my 1-month free trial

Install Management Studio

“

- [Instructor] SQL Server comes with a command line interface component that we can use to work with the server. And we can get to it by opening up a new command prompt by coming down to our search window and typing in CMD and that'll find our command prompt tool. Let's go and open that up. And the tool that I want to use inside of here is called SQL CMD or SQL Command. In order to connect to our server, I'll type in sqlcmd -S, the name of our computer, which my computer is Windows 10 dash PC, a backslash, and then the name of our SQL Server instance, which if you remember, I called mine SQL Server 2019. When I press enter, you'll notice that the prompt changes to this line number, so I'm on line number one inside of my SQL Server instance. And I can start issuing commands to the server. For instance, select @@version. When I press enter, that moves me down to line number two. I'll issue the command go and press enter again. And that'll return the current SQL Server version that I'm…

Contents