Keyboard Shortcuts in SQL Server


• Starting the SQL Server management studio Go to Start > Run and type the following command SQLWB
• To see the Object explorer press F8.
• To parse a Query you have written, press Ctrl + F5
• To Execute a Query, press F5 ( before executing you should always parse the query)
• Use F4 for properties window.
• You have options to show the output in Grid (default) or in Text format, Ctrl + D and Ctrl + T respectively) and I you want to output the results to a file use the combination Ctrl + Shift + F
• Ctrl + Shift + Q will display the Query Designer window.
• Display the execution plan using Ctrl + L, It is an advanced topic that we will cover later.
• Use Ctrl + K followed by Ctrl + C to comment out selected lines of code. Use Ctrl + K followed by Ctrl + U to uncomment the selection.
• Use Ctrl + Shift + U to make the selection Uppercase and use Ctrl + Shift + L to change it back to lower case
• Another common requirement is word wrapping for long queries, you may use the combination Ctrl + E followed by Ctrl + W
• Shift + Alt + Enter can be used to toggle between a full screen mode and a normal one.