08 April 2009

SQL Server Management Studio Tips – Part 2

This is the second in a series of posts highlighting Scott Cate’s video series of Visual Studio tricks over the last few months from Sara Ford’s blog.

As I mentioned in Part 1, many of the commands are documented in the  SQL Server 2008 help topic – SQL Server Management Studio Keyboard Shortcuts.

 

Blog Post Comments
#14 Word Wrap, and Word Wrap Glyph Toggling word wrap is handy in certain scenarios. You can also add the Toggle Word Wrap mode command to your toolbar.
#17 Keyboard Shortcut to Comment and Uncomment Code SSMS is slightly different. You need to do [CTRL]+[K] followed by [CTRL]+[C] to comment or [CTRL]+[U] to uncomment.
#20 Create New Line; Above and Below your Current Line This is handy because you can add the line without worrying about the current position in the line you are on.

[CTRL]+[ENTER] = Insert Line Above

  • (Same effect as [HOME],[ENTER],[UP])

[CTRL]+[SHIFT]+[ENTER] = Insert Line Below

  • (Same effect as [END],[ENTER])
#21 Transpose Characters, words, and lines in the editor This one doesn’t work completely SSMS.  Just these commands work:

[CTRL]+[SHIFT]+T = Transpose a word

[ALT]+[SHIFT]+T = Transpose a line
#22 Delete the beginning white space for selected line(s) Very handy way to remove indented white space with [CTRL]+[K] followed by [CTRL]+[\]
#24 Uppercase and Lowercase Keyboard Shortcuts SSMS is a little different on this post where:
[CTRL]+[SHIFT]+U = Make Uppercase
[CTRL]+[SHIFT]+L = Make Lowercase

Tomorrow – Part 3

TENA_blgr3_seeme

Filed under:
 

Comments

# SQL Server Management Studio Tips ??? Part 2 | Microsoft Share Point said:

PingBack from http://microsoft-sharepoint.simplynetdev.com/sql-server-management-studio-tips-%e2%80%93-part-2/

09 April 09 at 1:51 AM
# ComponentGear.com Feed said:

This week on Channel 9, Dan and Brian are joined by special guest Charles Torre! This week we discuss

10 April 09 at 11:27 PM
Anonymous comments are disabled
Page view tracker