Tip of the Day : Convert Oracle String Functions to SQL Server String Functions

SQL Server Helper - Tip of the Day

SQL Server 2012 Management Studio Keyboard Shortcuts - Microsoft IntelliSense

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