560 attributed reviews in the last 3 years
Refreshingly small course sizes
Outstandingly good courseware
Whizzy online classrooms
Wise Owls only (no freelancers)
Almost no cancellations
We have genuine integrity
We invoice after training
Review 30+ years of Wise Owl
View our top 100 clients
Introduction to SQL Server Management Studio
Part two of a two-part series of blogs
Before you get into writing SQL Queries you should take some time to familiarise yourself with the application in which you'll be spending most of your time. This blog shows you the basics of SQL Server Management Studio.
When you start creating queries you'll need to understand how to work with tabs. Each query window that you create will appear in a new tab at the top of the screen.
This screen contains two query windows, each in its own tab. The asterisk after the name of the leftmost tab indicates that it contains changes that have not been saved.
You can create new query windows quickly by pressing CTRL + N on the keyboard.
You can also click the New Query tool at the top left of the screen.
The simplest way to switch between tabs is to click on the one you want to view.
You can also click the drop arrow at the top right of the screen and choose a tab from the list that appears.
If you have lots of query windows open and you want to close (nearly) all of them you can right-click on a tab and choose the option shown below:
Choose the option shown to close all of the open tabs apart from the one on which you right-clicked.
If you want to close all of the open tabs, from the menu choose: Window > Close all Documents.
You can create horizontal and vertical groups of tabs to help you organise related query windows. The diagram below shows how to do this:
Right-click on a tab and choose either of the two bottom options shown here.
When you have selected one of the options shown above you'll end up with your query windows separated into different tab groups.
You can click and drag on the dividing line between the tab groups to change the height or width of the groups.
You can move a tab from one group to another by right-clicking on the tab and choosing the option shown in the diagram below:
Choosing the option shown will send the tab into the bottom half of the screen to sit alongside the other tabs in that group.
When you move the final tab out of a tab group that group will be removed.
|Parts of this blog|
25 Aytoun Street