SSMS Keyboard Shortcuts

Some keyboard shortcuts in SQL Server Management Studio:

New Query Window: ctl + N
Toggle between open query windows: ctrl + F6
Toggle between tabs on results window: F6
Close query window: ctl + F4
Results Pane on/off: ctl + R
Execution Plan: ctl + M
Comment out selected lines: ctrl + K,C
Un-comment selected lines: ctrl + K,U
Object Explorer: F8
Run Query: F5
Stop running query: alt + break
Parse Query: ctl + F5
Save: ctrl + S
Select multiple lines to edit all lines at once – add commas to all lines, etc.: alt + shift + arrow

A more comprehensive list is at:
Simple Talk

And a good post with shortcuts at:
Tech Recipes

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: