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
[CTRL]+[SHIFT]+[ENTER] = Insert Line Below
|
| #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
Technorati Tags: SQL Server Management Studio,SQL Server 2008,SQL Server 2005
