SQL Server Management Studio Tips – Part 3
This is the third 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 |
| #33 Drag and Drop techniques inside the Visual Studio Editor | This post shows how you can use the Ctrl key to make a copy of text you are dragging in the editor and how to drag text into a tabbed editor window. |
| #34 Cut and Paste Collapsed code in Visual Studio | With SQL Server 2008 Intellisense, it’s important to know how hidden text is impacted by cut/copy/paste. |
| #39 Middle button support in the Visual Studio Editor | I keep forgetting you can click on the wheel of the mouse to scroll. |
| #41 Forward and Backward navigation in Visual Studio Editor | Only [CTRL] + [-] works for moving back, but it’s still a handy time saver. If you want to add the tool bar button to your query editor toolbar, you’ll find Navigate Backwards in the View section. |
| #43 Select from Cursor to last “Go Back” marker in Visual Studio | This is real handy when you are moving the cursor and realize you want to select the text. [CTRL]+[=] = Select from current cursor position to last Go Back marker. |
| #44 Delete whole word (or whitespace) at a time forward and backwards | This is real handy for deleting columns in the project list. [CTRL]+[BACKSPACE] to delete the word to the left and [CTRL]+[DELETE] to delete words to the right. |
| #45 Move cursor to top or bottom of screen (without scrolling) | The use of [CTRL]+{UP ARROW] or [DOWN ARROW] keys to scroll without changing the cursor location is very handy. |
| #47 Swapping Anchor points (THIS IS COOL!) in Visual Studio | When not getting the initial selection right – this is very handy. In SSMS, the keystroke is actually [CTRL]+[K], [A] |
| #56 Show Shortcut Keys in Visual Studio Toolbar Tooltips | Great aid to learn keyboard shortcuts for toolbar buttons. |
On to Part 4 for tomorrow.
Technorati Tags: SQL Server Management Studio,SQL Server 2008,SQL Server 2005
