Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
SQL Server Management Studio Keyboard Shortcuts
常用快速鍵
SQL Server Management Studio Keyboard Shortcuts
https://msdn.microsoft.com/en-us/library/ms174205.aspx
| Action | SQL Server 2016 | SQL Server 2008 R2 |
|---|---|---|
| Select text from the cursor to the beginning of the document | CTRL+SHIFT+ HOME | CTRL+SHIFT+ HOME |
| Select text from the cursor to the end of the document | CTRL+SHIFT+END | CTRL+SHIFT+END |
| Select text from the cursor to the start of the current line | SHIFT+HOME | SHIFT+HOME |
| 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 |
| 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 |
SQL Snippets for SSMS 2008 R2