Action

SQL Server 2012

SQL Server 2008 R2

Toggle the full-screen display

SHIFT+ALT+ENTER

SHIFT+ALT+ENTER

Scroll text up one line

CTRL+UP ARROW

CTRL+UP ARROW

Scroll text down one line

CTRL+DOWN ARROW

CTRL+ DOWN ARROW

Reverse the last editing action

CTRL+Z or ALT+BACKSPACE

CTRL+Z

Restore the previously undone edit

CTRL+SHIFT+Z or CTRL+Y

CTRL+SHIFT+Z

Save the selected item

CTRL+S

CTRL+S

Save all

CTRL+SHIFT+S

CTRL+SHIFT+S

Close

CTRL+F4

CTRL+F4

Print

CTRL+P

CTRL+P

Exit

ALT+F4

ALT+F4

Open the current file in a browser

CTRL+SHIFT+W

No equivalent

Delete all text in the current file

CTRL+SHIFT+DEL

CTRL+SHIFT+DEL

Display the Go To Line dialog box

CTRL+G

CTRL+G

Display the Navigate To dialog box.

CTRL+PLUS SIGN (+)

No equivalent

Increase line indent

TAB

TAB

Decrease line indent

SHIFT+TAB

SHIFT+TAB

Make the selected text upper case

CTRL+SHIFT+U

CTRL+SHIFT+U

Make the selected text lower case

CTRL+U

CTRL+SHIFT+L

Make the selected text a comment

CTRL+K, CTRL+C

CTRL+K, CTRL+C

Uncomment the selected text

CTRL+K, CTRL + U

CTRL+K, CTRL + U

Open a new query with current

connection

CTRL+N

CTRL+N

Open database in Object Explorer

ALT+F8

ALT+F8

Specify values for template

Parameters

CTRL+SHIFT+M

CTRL+SHIFT+M

Run the selected portion of

the query editor or the entire

query editor if nothing is selected

Parse the selected portion of the

query editor or the entire query

F5 or CTRL+SHIFT+E

F5 or CTRL+E or ALT+X

editor if nothing is selected

CTRL+F5

CTRL+F5

Display the estimated execution plan

CTRL+SHIFT+ALT+L

CTRL+L

Cancel the executing query

ALT+BREAK

ALT+BREAK

Include actual execution plan in

the query output

CTRL+SHIFT+ALT+M

CTRL+M

Output results in a grid

CTRL+SHIFT+D

CTRL+D

Output results in text format

CTRL+T

CTRL+T

Output results to a file

CTRL+SHIFT+T

CTRL+SHIFT+F

Show or hide the query results pane

CTRL+R

CTRL+R

Show the query results pane

CTRL+SHIFT+ALT+R        

Toggle between query and results pane

F6

F6

Copy the result grid and headers to

the clipboard

CTRL+SHIFT+C

No equivalent

Move to the next active window in

Management Studio

ALT+F6

ALT+F6

Open SQL Server Profiler

CTRL+ALT+P

CTRL+ALT+P

Display the Query Designer dialog

from the query editor window

CTRL+SHIFT+Q

No equivalent

Run the sp_help system stored

Procedure

ALT+F1

ALT+F1

Run the sp_who system stored

Procedure

CTRL+1

CTRL+1

Run the sp_lock system stored

Procedure

CTRL+2

CTRL+2

Run the stored procedure configured

for this shortcut in the Tools, Options,

Keyboard, Query Shortcuts dialog

CTRL+3

CTRL+3

Run the stored procedure configured

for this shortcut in the Tools, Options,

Keyboard, Query Shortcuts dialog

CTRL+4

CTRL+4

Run the stored procedure configured

for this shortcut in the Tools,

Options, Keyboard, Query Shortcuts

Dialog

CTRL+5

CTRL+5

Run the stored procedure configured

for this shortcut in the Tools, Options,

Keyboard, Query Shortcuts dialog

CTRL+6

CTRL+6

Run the stored procedure configured

for this shortcut in the Tools,

Options, Keyboard, Query Shortcuts

Dialog

CTRL+7

CTRL+7

Run the stored procedure configured

for this shortcut in the Tools,

Options, Keyboard, Query Shortcuts

Dialog

CTRL+7

CTRL+7

Run the stored procedure configured

for this shortcut in the Tools,

Options, Keyboard, Query Shortcuts

Dialog

CTRL+8

CTRL+8

Run the stored procedure configured

for this shortcut in the Tools, Options,

Keyboard, Query Shortcuts dialog

CTRL+9

CTRL+9

Run the stored procedure configured

for this shortcut in the Tools,

Options, Keyboard, Query Shortcuts

Dialog

CTRL+0

CTRL+0