Shortcuts help you to do your work swiftly and with increased productivity. In this blog we’ll look at new query window shortcut every SQL Server geek should know
| Shortcut | Usage |
| Window + R -> ssms.exe | Open SQL Server management studio
|
| CTRL + N | Open a new query window
|
| CTRL + TAB | Move among open query windows
|
| CTRL + E | Execute All or selected queries |
| Ctrl + Shift + U | Convert selected text to upper case |
| Ctrl + Shift + L | Convert selected text to lower case |
| Ctrl + L | Display estimated execution plan
|
| Ctrl +Space | Intellisence – list members |
| CTRL + R | Show/Hide Result pane |
| Ctrl + M | Display Actual execution plan
|
| Ctrl + G | Go to a particular line number
|
| Alt + Break | Cancel executing query
|
| Ctrl + K, Ctrl + C | Comment selected lines
|
| Ctrl + K, Ctrl + U | Uncomment selected lines
|
| F5 | Execute all or selected queries in current query window |
| Alt | Switch to query window menu |
| Ctrl + K, Ctrl + X | Insert snippet
|
| Shift + Ctrl + Enter | Toggle between full screen and normal window
|
| Ctrl + T, Ctrl + E | Execute all or selected queries in current query window and display results in Text format |
| Ctrl + D, Ctrl + E | Execute all or selected queries in current query window and display results in Grid format |
Note: The above shortcuts are tested on SQL Server 2014.
Like us on FaceBook | Join the fastest growing SQL Server group on FaceBook
Great article…