10 SQL Server Shortcuts You Must Know

10 SQL Server Shortcuts You Must Know

Howdy Reader,

SQL Server is a relational database management system developed by Microsoft. As a database server, it is a software product with the primary function of storing and retrieving data as requested by other software applications which may run either on the same computer or on another computer across a network.

Many developers are familiar with using some of the below listed shortcuts for SQL Server Management Studio. Using keyboard is always preferred way of working as it boosts the working speed tremendously. Thus, thought of sharing my experience listing these shortcuts which I usually find helpful while working with SQL Server Management Studio.

10 SQL Server Shortcuts You Must Know Click To Tweet

#1. New Window

CTRL + N: Opens up a new Query Window in SQL Server Management Studio (SSMS).

#2. Comment Code

CTRL + K, CTRL + C: Comments the selected text.
CTRL + K, CTRL + U: Uncomments the selected text.

#3. Go to Line

CTRL + G: Go to specified line number in the current query window.

#4. Result Pane

CTRL + R: Shows/Hides the Result Pane. Toggle the query results.
CTRL + T: Display results to Text
CTRL + D: Display results to Grid
CTRL + SHIFT + F: Display results to File

#5. Change Case

CTRL + SHIFT + U: To change the selected text to UPPER CASE.
CTRL + SHIFT + L: To change the selected text to lower case.

10 SQL Server Shortcuts You Must Know

10 SQL Server Shortcuts You Must Know

#6. Intellisense

CTRL + SPACE, TAB: Using Ctrl + Space, suggestions would be given, and using Tab, you can complete that suggestion.

#7. Query Execution

F5 or ALT + X or CTRL + E: Execute all the queries written on query window.
CTRL + F5: Parse the query to check if there are any syntax errors.

#8. Profiler

CTRL + ALT + P: Opens up SQL Server Profiler. Profile is generally used for tracing and analyzing.

#9. System SP

ALT + F1: Select any stored procedure on query editor and press ALT + F1. It runs the sp_help system stored procedure.
CTRL + 1: In the same way it runs the sp_who system stored procedure. It will provide you the details like who created the SP, spid, host name, on which DB the SP was created and so on.

#10. Screen

SHIFT + ALT + ENTER: Toggle full screen mode.

Hope you found the post 10 SQL Server Shortcuts You Must Know useful and worth reading. Here is a post you might be interested in for 10 visual studio shortcuts you must know.

What do you think?

Dear Reader,
If you have any questions or suggestions please feel free to email us or put your thoughts as comments below. We would love to hear from you. If you found this post or article useful then please share along with your friends and help them to learn.

Happy Reading:)

  • Good one. In addition I personally like to assign shortcuts to queries in SQL Server. Instead of typing the same thing over and again. Saves a bit of time.