SQL Server Management Studio (SSMS) Tastatürkürzel 

SQL Server Management Studio (SSMS)    

Zeynel -
7 years ago
- Tastaturkürzel
0
Ctrl + +

Expand or collapse selected pane

0
Ctrl + ↑  Shift + I

Reverse incremental search so it starts at the bottom of the file and searches to the top

0
Ctrl + 4

Run the stored procedure configured for this shortcut in the Tools, Options, Keyboard, Query Shortcuts dialog

0
Ctrl + 4

Displays the results pane of the Query Designer

0
↑  Shift +

Select text up line by line starting from the cursor

0
↑  Shift +

Decreases the height of the selected control in increments of 8

0
Ctrl + End

Move the cursor to the end of the document

0
↑  Shift +

Select text down line by line starting from the cursor

0
↑  Shift +

Increases the height of the selected control in increments of 8

0
Insert

Toggle between insert mode and overtype mode

0
Ctrl + F4

Close the current MDI child window

0
Ctrl + F4

Closes Activity Monitor

0
Ctrl + ↑  Shift + O

Display the Open Project dialog box to open an existing project

0
Alt +

Drop-down for filtering in grid

0
Ctrl + ↑  Shift + U

Make the selected text upper case

1
Ctrl + ↑  Shift + U

Change the selected text to uppercase

0
↑  Shift + F3

Find the previous occurrence of the search text

0
Ctrl + Del

Delete the word to the right of the cursor

0
Ctrl + /

Place the caret in the Find/Command box of the Standard toolbar

0
Ctrl + ↑  Shift + Tab

Cycle through the previous MDI child windows

0
Ctrl + ↑  Shift + Tab

Move to the previous document in the editor or designer

0
Ctrl + ]

Jump between syntax pairs

0
Ctrl + ↑  Shift + H

Display the Replace in Files dialog box

0
Ctrl + 5

Run the stored procedure configured for this shortcut in the Tools, Options, Keyboard, Query Shortcuts dialog

0
Ctrl + ↑  Shift + W

Open the current file in a browser

0
Ctrl + Page Down

Moves the cursor to the bottom of the document

0
Ctrl + Page Down

Moves to the next tab in the document

-1
↑  Shift + Del

Cut (delete the currently selected item and place it to the Clipboard)

0
Ctrl + Page Up

Moves the cursor to the top of the document

0
Ctrl + Page Up

Moves to the previous tab in the document

0
Ctrl + ↑  Shift + K

then Ctrl + Shift + N: If the current bookmark is in a folder, moves to the next bookmark in the folder. Bookmarks outside the folder are skipped. If the bookmark is not in a folder, moves to the next bookmark at the same level. If the Bookmarks window contains folder, bookmarks in folders are skipped

0
Ctrl + ↑  Shift + K

then Ctrl + Shift + P:  If the current bookmark is in a folder, moves to the next bookmark in the folder. Bookmarks outside the folder are skipped.  If the bookmark is not in a folder, moves to the next bookmark at the same level. If the Bookmarks window contains folder, bookmarks in folders are skipped.

0
Ctrl + 6

Run the stored procedure configured for this shortcut in the Tools, Options, Keyboard, Query Shortcuts dialog

0
Ctrl + Backspace

Delete the word to the left of the cursor

0
↑  Shift + F5

Stop debugging

1
↑  Shift + F10

Display the context menu

0
Ctrl + ↑  Shift +

Extend the selection one word to the right

0
Ctrl + ↑  Shift +

Extend the selection one word to the left

0
Ctrl + Alt + C

Display the Call Stack window

1
Ctrl + F6

Cycle through the next MDI child windows

0
Ctrl + 9

Run the stored procedure configured for this shortcut in the Tools, Options, Keyboard, Query Shortcuts dialog

1
↑  Shift + F6

(in the Database Engine Query Editor) Move to the next pane of a split pane view of a single document

0
↑  Shift + F6

Move to the previous pane of a split pane view of a single document

0
Ctrl + 8

Run the stored procedure configured for this shortcut in the Tools, Options, Keyboard, Query Shortcuts dialog

0
↑  Shift + F6

Move to the previous pane of a document in split pane view

0
Ctrl + 7

Run the stored procedure configured for this shortcut in the Tools, Options, Keyboard, Query Shortcuts dialog

0
oder Ctrl + 7
0
Ctrl + F5

Parse the selected portion of the query editor or the entire query editor if nothing is selected

0
Ctrl + F3

Find the next occurrence of the currently selected text

1
Ctrl + Alt + T

Display Template Explorer

-1
Ctrl + F2

Moves the insertion point to the drop-down bar located at the top of the code editor when the editor is in Code view or Server Code view

0
Ctrl + Alt + R

Display the Browser Window

0
Ctrl + Insert

Copy to the Clipboard

0
↑  Shift + End

Select text from the cursor to the end of the current line

0
Ctrl + F1

Display SQL Server Books Online

0
↑  Shift + F1

Display help for the current editor window

0
↑  Shift + Insert

Paste from the Clipboard at the insertion point

1
↑  Shift + Home

Select text from the cursor to the start of the current line

0
Ctrl + Alt + L

Display Solution Explorer

Werbung

0
Ctrl + Alt + P

Open SQL Server Profiler

0
Ctrl + Alt + L

Display Solution Explorer

0
Ctrl + =

Select the current location in the editor, back to the previous location in the editor

0
Ctrl + =

Select the text from the current location of the cursor to the Navigate Backward (Ctrl + -) location

0
Ctrl + F9

Enable breakpoint

1
Ctrl + ↑  Shift + ⤶ Enter

Insert a blank line below the cursor

0
Ctrl + ↑  Shift + J

Enables JOIN mode in the Query Designer

0
↑  Shift + F8

Returns the cursor to the last item

0
↑  Shift + F9

Display the QuickWatch dialog box

0
Ctrl + Alt + I

Display the Immediate window

0
↑  Shift + F12

Displays the list of references for the selected symbol

0
Shift + Page Up

Extend selection up one page

0
Ctrl + \

then T: Display the Task List window

1
Ctrl + \

then Ctrl + T: Display the Task List window

0
Ctrl + \

then Ctrl + E  Display the Error List Window (Transact-SQL Editor only)

0
Ctrl + \

E Display a smart tag menu of common commands for Web server controls in the HTML designer

0
Ctrl + \

then E   Display the Error List Window (Transact-SQL Editor only)

0
Shift + Page Down

Extend selection down one page

0
Ctrl + Alt + B

Display the Breakpoints window

0
Ctrl + Alt +

Display a popup listing all open windows

-1
Ctrl + ↑  Shift + Q

Display the Query Designer

0
Ctrl + ↑  Shift + Q

Display the Query Designer dialog from the query editor window

1
Ctrl + ↑  Shift + Home

Select text from the cursor to the beginning of the document

1
Ctrl + ↑  Shift + End

Select text from the cursor to the end of the document

0
Ctrl + ↑  Shift + Space

Display parameter information

0
Ctrl + Alt + G

Display Registered Servers

0
Alt + F1

Run the sp_help system stored procedure

0
Ctrl + Alt + O

Display the Output window

0
↑  Shift + Alt +

Moves the cursor one character to the right and extends the column selection

0
↑  Shift + Alt +

Move the cursor up one line, extending the selection

0
Ctrl + F10

Implement the Run To Cursor command

0
↑  Shift + Alt +

Moves the cursor one character to the left and extends the column selection

0
Alt + F8

Open database in Object Explorer

0
↑  Shift + Esc

Close the current tool window

0
Ctrl + ↑  Shift + -

Go forward to the next document or window in the navigation history

0
Alt + Backspace

Reverse the last editing action

0
↑  Shift + Ctrl + Del

Moves the cursor down one line, extending the column selection

0
Ctrl + ↑  Shift + Del

Delete all text in the current file

0
Alt + F7

Display the IDE navigator with the first tool window selected

0
Ctrl + Alt + H

Display the Threads window

0
Ctrl + ↑  Shift + ]

Move the cursor to the next brace, extending the selection

0
*

(on the numeric keypad) Expand all tree nodes

0
↑  Shift + Backspace

Delete one character to the left of the cursor

0
↑  Shift + Alt + T

Moves the line containing the cursor below the next line

0
Alt + .

Changes the IntelliSense filter level from the All tab to the Common tab

0
Alt + -

Display the dock menu

0
Alt + F5

Start or continue debugging

0
↑  Shift + Alt + A

Display the Add Existing Item dialog box to add an existing file to the current project

0
Ctrl + Shift + Page Up

Extend the selection to the top of the current window

0
Ctrl + Shift + Page Down

Move the cursor to the last line in view, extending the selection

0
Ctrl + Shift + Page Up

Moves the cursor to the first line in view, extending the selection

0
Ctrl + Shift + Page Down

Moves the cursor to the last line in view, extending the selection

0
Ctrl + ↑  Shift + F3

Find the previous occurrence of the currently selected text

0
Ctrl + Alt + X

Display the Toolbox

0
Alt + F6

Move to the next tool window

0
Alt + F6

Move to the next active window in Management Studio

0
Ctrl + ↑  Shift + F6

Move to the previous document in the editor or designer

0
Ctrl + ↑  Shift + F9

Delete all breakpoints

0
Ctrl + Alt + Q

Display the QuickWatch dialog box

0
Ctrl + ↑  Shift + Alt + C

Copy parameter tip

0
Ctrl + ↑  Shift + Alt + R

Show the query results pane

-1
Alt + +

Activate the menu for a tool component

0
Ctrl + ↑  Shift + F12

Move to the next entry in the Error List window (Transact-SQL Editor only)

0
Alt + +

Changes the IntelliSense filter level from the Common tab to the All tab

0
Ctrl + ↑  Shift + Insert

Pastes an item from the Clipboard Ring at the insertion point and automatically selects the pasted item

0
Ctrl + ↑  Shift + Alt + P

Paste parameter tip

0
Ctrl + ↑  Shift + Alt +

Move the cursor to the right one word, extending the selection

0
Ctrl + ↑  Shift + Alt +

Move the cursor to the left one word, extending the selection

0
↑  Shift + Alt

Move to the current tool window toolbar

0
Ctrl + ↑  Shift + Alt + L

Display the estimated execution plan

0
Ctrl + ↑  Shift + Alt + M

Include actual execution plan in the query output

1
↑  Shift + Alt + F10

Display a smart tag menu of common commands for Web server controls in the HTML designer

0
↑  Shift + Alt + ⤶ Enter

Toggle the full-screen display

0
Ctrl + Alt +   

Scroll up or down Activity Monitor

0
↑  Shift + Alt + F11

Step into specific statement

0
Ctrl + Alt + F1

Open the Help Library Manager

0
↑  Shift + Alt + Home

Moves the cursor to the start of the current line and extends the column selection

0
Alt + ↑  Shift + Backspace

Restore the previously undone edit

0
Ctrl + Alt + F2

Display the SQL Server Resource Center Web page

0
↑  Shift + Alt + End

Moves the cursor to the end of the line, extending the column selection

1
↑  Shift + Alt + F6

Move to the previously selected window

0
Ctrl + K Dann Ctrl + U

Remove the comment syntax from the current line

0
↑  Shift + Alt + F7

Move to the previous tool window

0
Ctrl + Alt + Break

Break all

0
Ctrl + K Dann Ctrl + X

Launch code snippet picker

0
Ctrl + K Dann Ctrl + I

Display quick information

0
Ctrl + K Dann Ctrl + B

Display the Code Snippet Manager

0
Ctrl + K Dann Ctrl + F

Correctly indents the selected lines of code based on the surrounding lines of code

0
Ctrl + K Dann Ctrl + S

Launch Surround With snippet picker

0
Ctrl + M Dann Ctrl + S

Collapses the currently selected outlining region

0
Ctrl + M Dann Ctrl + O

Collapses existing outlining regions


Teilen Sie diese Seite auf:
Ist diese Seite hilfreich?
0 0

Was ist Ihr Lieblings-Hotkey für SQL Server Management Studio (SSMS) ? Habt ihr dazu nützliche Tipps? Informieren Sie unten andere Benutzer darüber.


Nur registrierte Benutzer können Links posten.
 
Noch keine Kommentare. Fragen Sie oder geben Sie den ersten ein!

Neueste Artikel