2016年11月11日 星期五

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
ActionSQL Server 2016SQL Server 2008 R2
Select text from the cursor to the beginning of the documentCTRL+SHIFT+ HOMECTRL+SHIFT+ HOME
Select text from the cursor to the end of the documentCTRL+SHIFT+ENDCTRL+SHIFT+END
Select text from the cursor to the start of the current lineSHIFT+HOMESHIFT+HOME
Display the Go To Line dialog boxCTRL+GCTRL+G
Display the Navigate To dialog box.CTRL+PLUS SIGN (+)No equivalent
Increase line indentTABTAB
Decrease line indentSHIFT+TABSHIFT+TAB
Make the selected text upper caseCTRL+SHIFT+UCTRL+SHIFT+U
Make the selected text lower caseCTRL+UCTRL+SHIFT+L
Make the selected text a commentCTRL+K, CTRL+CCTRL+K, CTRL+C
Uncomment the selected textCTRL+K, CTRL + UCTRL+K, CTRL + U
Run the sp_help system stored procedureALT+F1ALT+F1
Run the sp_who system stored procedureCTRL+1CTRL+1
Run the sp_lock system stored procedureCTRL+2CTRL+2
Run the stored procedure configured for this shortcut in the Tools, Options, Keyboard, Query Shortcuts dialogCTRL+3CTRL+3
Run the stored procedure configured for this shortcut in the Tools, Options, Keyboard, Query Shortcuts dialogCTRL+4CTRL+4
SQL Snippets for SSMS 2008 R2




沒有留言:

SQL Server Planning, Pricing and License

  Server-CALs授權模式 1.需購買的量應該是所有終端用戶的電腦 例如:一台Data warehouse主機 與 一台Web報表主機,但公司有50人或電腦會連進Web報表主機開啟報表,則應該每一台用戶端電腦都需要有CALs授權,Data warehouse主機購買Ser...