Wednesday, January 19, 2011

 

Useful SSMS Shortcuts

Here are a few useful SSMS shortcuts:

Ctrl-N  Open a new tabbed query window (with same credentials as current tab)
Ctrl–K + Ctrl–C / Ctrl–K + Ctrl–U Comment / Uncomment selected text
Ctrl-Shift-U / Ctrl-Shift-L Change selected text to upper / lowercase (wish it just affected keywords!)
Ctrl-L Include estimated execution plan
Ctrl-K Include actual execution plan
Ctrl+R Toggle Results pane
F4 Show Properties window
Ctrl+Shift+M Specify values for template parameters

Usual Suspects

Ctrl-F, Ctrl-H : Find/Replace

F5 or Ctrl-E   : Execute query



    

Powered by Blogger