Menu Activation
- Move to the menu bar | ALT
- Activate the menu for a tool component | Alt + -
- Display the context menu | Shift + F10
- Display the Query Designer | Ctrl + Shift + Q
- Diplay the New File dialog box | Ctrl + N
- Display the New Project dialog box | Ctrl + Shift + N
- Display the Open File dialog box | Ctrl + O
- Display the Open Project dialog box | Ctrl + Shift + O
- Display the Add New Item Dialog Box | Ctrl + Shift + A
- Display the Add Existing Item Dialog Box | Shift + Alt + A
- Close a menu or dialog box, canceling the action | Esc
Windows Management and Toolbar
- Close the current MDI child window | Ctrl + F4
- Close a menu or dialog box | Esc
- Print | Ctrl + P
- Exit | Alt + F4
- Toggle full screen mode | Shift + Alt + Enter
- Close the current tool window | Shift + Esc
- Cycle through the next MDI child windows | Ctrl + F6
- Display the IDE navigator | Ctrl + Tab
- Cycle through the previous MDI child windows | Ctrl + Shift + Tab
- Moves the insertion point to the drop-down bar | Ctrl + F2
- Move to the current tool window toolbar | Shift + Alt
Windows Management and Toolbar
- Display the IDE navigator | Alt + F7
- Move to the next tool window | Alt + F6
- Move to the previous tool window | Shift + Alt + F7
- Move to the next pane of a split pane view | F6
- Move to the previously selected window | Shift + Alt + F6
- Move to the previous pane of a split pane view of a single document| Shift + F6
- Display the dock menu | Alt + -
- Display a popup listing all open windows | Ctrl + Alt +(down arrow)
- Opens a new query editor window | Ctrl + O
- Display Object Explorer | F8
- Display Registered Servers | Ctrl + Alt + G
Windows Management and Toolbar
- Display Template Explorer | Ctrl + Alt + T
- Display Solution Explorer | Ctrl + Alt + L
- Display the Summary Window | F7
- Display the Properties Window | F4
- Display the Output window | Ctrl + Alt + O
- Display the Task List window | Ctrl + \ + T
- Toggle between Object Explorer Details list
view and Object Explorer Details property pane | F6
- Display the Toolbox | Ctrl + Alt + X
- Display the Bookmarks Window | Ctrl + K
- Display the Browser Window | Ctrl + Alt + R
- Display a smart tag menu of common
commands for Web server controls | Shift + Alt + F10
Windows Management and Toolbar
- Display the Error List Window | Ctrl + E
- Move to the next entry in the Error List window | Ctrl + Shift + F12
- Display the previous page in the viewing history | Alt + (left arrow)
- Display the next page in the viewing history* | Alt + (right arrow)
Cursor Movement
- Move the cursor left | (left arrow)
- Move the cursor right | (right arrow)
- Move the cursor up | (up arrow)
- Move the cursor down | (down arrow)
- Move the cursor to the beginning of the line | Home
- Move the cursor to the end of the line | End
- Move the cursor to the beginning of the document | Ctrl + Home
- Move the cursor to the end of the document | Ctrl + End
- Move the cursor up one screen | PgUp
- Move the cursor down one screen | PgDn
- Moves the cursor one word to the right | Ctrl + (right arrow)
- Moves the cursor one word to the left | Ctrl + (left arrow)
- Returns the cursor to the last item | Shift + F8
- Moves the cursor to the top of the document | Ctrl + PgUp
- Moves to the previous tab in the document | Ctrl + PgUp
- Moves the cursor to the bottom of the document | Ctrl + PgDn
- Moves to the next tab in the document | Ctrl + PgDn
Text Selection
- Select text from the cursor to the
beginning of the document | Ctrl + Shift + Home
- Select text from the cursor to the end
of the document | Ctrl + Shift + End
- Select text from the cursor to the start
of the current line | Shift + Home
- Moves the cursor to the start of the current
line and extends the column selection | Shift + Alt + Home
- Select text from the cursor to the
end of the current line | Shift + End
- Moves the cursor to the end of the line,
extending the column selection | Shift + Alt + End
- Select text down line by line
starting from the cursor | Shift + (down arrow)
- Moves the cursor down one line,
extending the column selection | Shift + Alt + End
- Moves the cursor one character to the
left and extends the selection | Ctrl + Shift + Del
- Moves the cursor one character to the
left and extends the selection | Shift + (left arrow)
- Moves the cursor one character to the
right and extends the selection | Shift + (right arrow)
- Moves the cursor one character to the
left and extends the column selection | Shift + Alt + (left arrow)
- Moves the cursor one character to the
right and extends the column selection | Shift +Alt + (right arrow)
- Move the cursor up one line, extending the selection | Shift + Alt + (up arrow)
- Extend selection up one page | Shift + PgUp
- Extend selection down one page | Shift + PgDn
- Select the entire current document | Ctrl + A
- Select the word containing the
cursor, or the closest word | Ctrl + W
- Select the current location in the editor,
back to the previous location in the editor | Ctrl + =
- Extend the selection to the top of the
current window | Ctrl + Shift + PgUp
- Move the cursor to the last line in view,
extending the selection | Ctrl + Shift + PgDn
- Extend the selection one word to the right | Ctrl + Shift + (right arrow)
- Extend the selection one word to the left
- Move the cursor to the right one
word, extending the selection | Ctrl + Shift + (left arrow)
- Move the cursor to the left one
word, extending the selection | Ctrl + Shift + Alt + (right arrow)
- Move the cursor to the next
brace, extending the selection | Ctrl + Shift + Alt + (left arrow)
- Select the text from the current location
of the cursor to the Navigate Backward | Ctrl + Shift + ]
- Go back to the previous document or
window in the navigation history | Ctrl + =
- Go forward to the next document or
window in the navigation history | Ctrl + -
- Swaps the anchor and end points of the
current selection | Ctrl + A
- Moves the cursor to the first line in
view, extending the selection | Ctrl + Shift + PgUp
- Moves the cursor to the last line in
view, extending the selection | Ctrl + Shift + PgDn
Bookmark Keyboard
- Set or remove a bookmark at the current line | Ctrl + K
- Next bookmark | Ctrl + N
- If the current bookmark is in a folder,
move to the next bookmark in the folder | Ctrl + Shift + K
- Previous bookmark | Ctrl + P
- Clear bookmarks | Ctrl + L
Tree Control
- Collapse tree nodes | - (On the numeric keypad)
- Expand all tree nodes | * (On the numeric keypad)
- Scroll the tree control up in the window | Ctrl + (up arrow)
- Scroll the tree control down in the window | Ctrl + (down arrow)
Code Editor
- Toggle the full-screen display | Shift + Alt + enter
- Scroll text up one line | Ctrl + (up arrow)
- Scroll text down one line | Ctrl + (down arrow)
- Reverse the last editing action | Ctrl + Z
- Restore the previously undone edit | Ctrl + Shift + Z
- Save the selected item | Ctrl + S
- Save all | Ctrl + Shift + S
- Close | Ctrl + F4
- Print | Ctrl + P
- Exit | Alt + F4
- Open the current file in a browser | Ctrl + Shift + W
- Delete all text in the current file | Ctrl + Shift + Del
- Display the Go To Line dialog box | Ctrl + G
- Display the Navigate To dialog box | Ctrl + (+)
- Increase line indent | Tab
- Decrease line indent | Shift + Tab
- Make the selected text upper case | Ctrl + Shift + U
- Make the selected text lower case | Ctrl + U
- Make the selected text a comment | Ctrl + C
- Uncomment the selected text | Ctrl + K
- Open a new query with current connection | Ctrl + N
- Open database in Object Explorer | Alt + F8
- Specify values for template parameters | Ctrl + Shift + M
- Run the selected portion of the query editor or
the entire query editor if nothing is selected | F5
- Parse the selected portion of the query editor
or the entire query editor if nothing is selected | Ctrl + F5
- Display the estimated execution plan | Ctrl + Shift + Alt + L
- Cancel the executing query | Alt + Break
- Include actual execution plan in the query output | Ctrl + Shift + Alt + M
- Output results in a grid | Ctrl +Shift + D
- Output results in text format | Ctrl + T
- Output results to a file | Ctrl + Shift + T
- Show or hide the query results pane | Ctrl + R
- Show the query results pane | Ctrl + Shift + Alt + R
- Toggle between query and results pane | F6
- Copy the result grid and headers to the clipboard | Ctrl + Shift + C
- Move to the next active window in Management Studio | Alt + F6
- Open SQL Server Profiler | Ctrl + Alt + P
- Display the Query Designer dialog from
the query editor window | Ctrl + Shift + Q
- Run the sp_help system stored procedure | Alt + F1
- Run the sp_who system stored procedure | Ctrl + 1
- Run the sp_lock system stored procedure | Ctrl + 2
- Run the stored procedure configured for this shortcut
in the Tools, Options, Keyboard, Query Shortcuts
dialog | Ctrl + 3
- Run the stored procedure configured for this shortcut
in the Tools, Options, Keyboard, Query Shortcuts
dialog | Ctrl + 4
- Run the stored procedure configured for this shortcut
in the Tools, Options, Keyboard, Query Shortcuts
dialog | Ctrl + 5
- Run the stored procedure configured for this shortcut
in the Tools, Options, Keyboard, Query Shortcuts dialog | Ctrl + 6
- Run the stored procedure configured for this shortcut
in the Tools, Options, Keyboard, Query Shortcuts dialog | Ctrl + 7
- Run the stored procedure configured for this shortcut
in the Tools, Options, Keyboard, Query Shortcuts dialog | Ctrl + 8
- Run the stored procedure configured for this shortcut
in the Tools, Options, Keyboard, Query Shortcuts dialog | Ctrl + 9
- Run the stored procedure configured for this shortcut
in the Tools, Options, Keyboard, Query Shortcuts dialog | Ctrl + 0
Text Manipulation in Code Editor Keyboard Shortcuts
- Insert a new line | Shift + Enter
- Swap the characters on either side of the
cursor (Does not apply to the SQL Editor.) | Ctrl + T
Delete one character to the right of the cursor | Del
- Delete one character to the left of the cursor | (<- backspace)
Code Editor (page 135)
- Insert the number of spaces configured for the editor | Tab
- Insert a blank line above the cursor | Ctrl + Enter
- Insert a blank line below the cursor | Ctrl + Shift + Enter
- Change the selected text to lowercase | Ctrl + Shift + L
- Change the selected text to uppercase | Ctrl + Shift + U
- Toggle between insert mode and overtype mode | Ins
- Move selected lines to the left on tab stop | Shift + Tab
- Delete the word to the right of the cursor | Ctrl + Del
- Delete the word to the left of the cursor | Ctril + (<- backspace)
- Transpose the words on either side of the cursor
(Does not apply to the SQL Editor.) | Ctrl + Shift + T
- Moves the line containing the cursor below the next line| Shift + Alt + T
- Correctly indents the selected lines of code based
on the surrounding lines of cod | Ctrl + F
- Set or remove a shortcut in the current line | Ctrl + H
- Remove the comment syntax from the current line | Ctrl + U
- Shows or hides spaces and tabs | Ctrl + R
- Enables or disables word wrap in an editor | Alt + F
- Collapses all outlining regions to show just the
outermost groups in the hierarchy | Ctrl + M
- Collapses the currently selected outlining region | Ctrl + S
- Expands all outlining regions on the page | Ctrl + X
- Expands the currently selected outlining region | Ctrl + E
- Collapses existing outlining regions | Ctrl + O
- Hides the selected text.
A signal icon marks the location of the hidden text| Ctrl + H
- Break at function | Ctrl + B
- Display the Watch 1 window | Ctrl + Alt + W + 1
- Display the Watch 2 window | Ctrl + Alt + W + 2
- Display the Watch 3 window | Ctrl + Alt + W + 3
- Display the Watch 4 window | Ctrl + Alt + W + 4
- Display the Autos window | Ctrl + Alt + V + A
- Display the Locals window | Ctrl + Alt + V + L
- Display the Immediate window | Ctrl + Alt + I
- Display the Call Stack window | Ctrl + Alt + C
- Display the Threads window | Ctrl + Alt + H
- Display the Parallel Stacks window. | Ctrl + Shift + D + S
- Toggles all text sections previously marked as
hidden between the hidden and display states. | Ctrl + L
- Toggles the currently selected hidden text
section between the hidden and display states | Ctrl + M
- Removes all outlining information in the document | Ctrl + P
- Removes the outlining information for the
currently selected region | Ctrl + U
Transact-SQL Debugger (pg. 139)
- Start or continue debugging | Alt + F5
- Stop debugging | Shift + F5
- Step into | F11
- Step over | F10
- Step out | Shift + F11
- Step into specific statement | Shift + Alt + F11
- Set next statement | Ctrl + 3
- Show next statement | Alt + Num
- Implement the Run To Cursor command | Ctrl + F10
- Display the QuickWatch dialog box | Ctrl + Alt + Q
- Toggle breakpoint | F9
- Enable breakpoint | Ctrl + F9
- Delete the breakpoint.
Only available in the Breakpoints window | ALT + F9, D
- Open the Edit breakpoint labels dialog.
Only available in the Breakpoints window | AlT + F9, L
- Open the Edit breakpoint labels dialog.
Only available in the Breakpoints window | Ctrl + Shift + F9
- Open the Edit breakpoint labels dialog.
Only available in the Breakpoints window | Ctrl + Alt + B
- Break all | Ctrl + Alt + Break
- Display the Parallel Tasks window | Ctrl + Shift + D + K
Microsoft IntelliSense Shortcuts (pg 140)
- List members | Ctrl + J
- Complete word | Ctrl + Space
- Display quick information | Ctrl + K
- Display parameter information | Ctrl + Shift + Space
- Copy parameter tip | Ctrl + Shift + Alt + C
- Paste parameter tip | Ctrl + Shift + Alt + P
- Jump between syntax pairs | Ctrl + ]
- Launch code snippet picker | Ctrl + X
- Refresh local cache | Ctrl + Shift + R
- Launch Surround with Snippet Picker | Ctrl + K
- Display the Code Snippet Manager | Ctrl + B
- Changes the IntelliSense filter level from the Common
tab to the All tab | Alt + (+)
- Changes the IntelliSense filter level from the All
tab to the Common tab | Alt + (.)
Document Window and Browser
- Toggle full-screen mode | Shift + Alt + Enter
- Move to the next pane of a split pane view of a document | F6
- Move to the previous document in the editor or designer | Ctrl + Shift + F6
- Move to the previous pane of a document in split pane view | Shift + F6
- Back, display the previous page in the viewing history | Alt + (left arrow <-)
- Forward, display the next page in the viewing history | Alt + (right arrow ->)
- Closes a menu or dialog box, cancels an operation in progress,
or places focus in the current window | Esc
Solution Explorer
- Display Solution Explorer | Ctrl + Alt + L
- Display the New File dialog box to create a new file | Ctrl + N
- Display the New Project dialog box to create a new project | Ctrl + Shift + N
- Display the Open File dialog box to open an existing file | Ctrl + O
- Change the name of the selected object | F2
Help and Books Online
- Display help for the current editor window | Shift + F1
- Help | F1
- Display SQL Server Books Online | Ctrl + F1
- Open the Help Library Manager | Ctrl + Alt + F1
- Display the SQL Server Resource Center Web page | Ctrl + Alt + F2
- Display help for the current editor window | Shift + F1
Search
- Display the Find dialog box | Ctrl + F
- Displays the definition for the selected symbol | F12
- Display the Replace dialog box | Ctrl + H
- Start incremental search | Ctrl + I
- Find the next occurrence of the previous search text | F3
- Find the previous occurrence of the search text | Shift + F3
- Display the Replace in Files dialog box | Ctrl + Shift + H
- Reverse incremental search so it starts at the bottom
of the file and searches to the top | Ctrl + Shift + I
- Select or clear the Search up option in Find and Replace | Alt + F3 + B
- Stop the Find in Files search | Alt + F3 + S
- Select or clear the Find whole word option in Find and Replace| Alt + F3 + W
- Selects or clears the Wildcard option in Find and Replace | Alt + F3 + P
- Place the caret in the Find/Command box of the Standard toolbar| Ctrl + /
Cut and Paste
- Cut | Ctrl + X
- Cuts all of the selected lines, or the current line if nothing is selected| Ctrl + L
- Paste from the Clipboard at the insertion point | Ctrl + C
- Pastes an item from the Clipboard Ring at the insertion point| Ctrl + V
Paste from the Clipboard at the insertion point
Activity Monitor
- Launches Activity Monitor | Ctrl + Alt + A
- Closes Activity Monitor | Ctrl + F4
- Refresh | F5
- Filter the monitor display | Ctrl + Shift + F
- Launches Activity Monitor | F6
- Expand or collapse selected pane | Ctrl + (+) or (-)
- Expand or collapse all panes | (+) or (-)
- Copies entire selected row in grid | Ctrl + C
- Copy cell | Ctrl + Shift + C
- Drop-down for filtering in grid | Alt + (arrow down)
- Scroll up or down Activity Monitor | Ctrl + Alt + (up arrow) or (dn arrow)
Replication Conflict Viewer
- Define filter | F6
- Apply filter | F7
- Show all columns | F8
Query Designer
- Cancels or stops the currently running query | Ctrl + T
- Displays the diagram pane of the Query Designer | Ctrl + 1
- Displays the criteria pane of the Query Designer | Ctrl + 2
- Displays the SQL pane of the Query Designer | Ctrl + 3
- Displays the results pane of the Query Designer | Ctrl + 4
- Run the query specified in the Query Designer | Ctrl + R
- When in the results pane, moves focus to the tool
strip docked at the bottom of the designer | Ctrl + G
- Enables JOIN mode in the Query Designer | Ctrl + Shift + J
Designer
- Move the selected control up in increments of 8 on the design surface | (dn arrow)
- Move the selected control left in increments of 8 on the design surface | (left arrow)
- Move the selected control down in increments of 8 on the design surface | (right arrow)
- Move the selected control right in increments of 8 on the design surface | (up arrow)
- Increases the height of the selected control in increments of 8 | Shift + (dn arrow)
- Reduces the width of the selected control in increments of 8 | Shift + (left arrow)
- Increases the width of the selected control in increments of 8 | Shift + (right arrow)
- Decreases the height of the selected control in increments of 8 | Shift + (up arrow)
- Moves to the next control on the page | Tab
- Moves to the previous control on the page | Shift + Tab
- Display the grid on the design surface | Enter
_edited_edited.jpg)
Comentários