SQL Server Management Studio Keyboard Shortcuts
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