Skip Navigation Links
Home
Articles
SQL Server 2012
SQL Server 2014
SQL Server 2016
FAQ
Forums
Practice Test
Bookstore
Tip of the Day : Query String Parser Function
SQL Server Helper
Home > > Tip of the Day
SQL Server Helper - Tip of the Day

SQL Server 2012 Management Studio offers users two keyboard schemes.  By default, it uses the SQL Server 2012 scheme, with keyboard shortcuts based on Microsoft Visual Studio 2010.  Management Studio also offers a keyboard scheme similar to the standard scheme from SQL Server 2008 R2.  To change the keyboard scheme or add additional keyboard shortcuts, on the Tools menu, click Options.  Select the desired keyboard scheme on the Environment, Keyboard page.


Action SQL Server 2012 SQL Server 2008 R2
List members CTRL+J CTRL+SPACE OR CTRL+J
Complete word CTRL+SPACE OR ALT+RIGHT ARROW ALT+RIGHT ARROW
Display quick information CTRL+K, CTRL+I No Equivalent
Display parameter information CTRL+SHIFT+SPACE CTRL+SHIFT+SPACE
Copy parameter tip CTRL+SHIFT+ALT+C No Equivalent
Paste parameter tip CTRL+SHIFT+ALT+P No Equivalent
Jump between syntax pairs CTRL+J CTRL+J
Launch code snippet picker CTRL+K, CTRL+X CTRL+K, CTRL+Z
Refresh local cache CTRL+SHIFT+R CTRL+SHIFT+R
Launch Surround With snippet picker CTRL+K, CTRL+S CTRL+K, CTRL+S
Display the Code Snippet Manager CTRL+K, CTRL+B No Equivalent
Change the IntelliSense filter level from the Common tab to the All tab ALT+PLUS SIGN (+) No Equivalent
Change the IntelliSense filter level from the All tab to the Common tab ALT+PERIOD (.) No Equivalent

Back to Tip of the Day List Next Tip