NULL shortcut key in Sql Server Management Studio (SSMS)

Sometimes you are manually editing a row in the table pane in Sql Server Management Studio (SSMS) and you need to put NULL in a column. An easy shortcut key is, whilst the cursor is in the column:

CTRL + 0

Incremental search in Visual Studio

If you have a long piece of code and your're finding that you are constantly scrolling up and down...

You can do a "search as you type" in Visual Studio 2010 to find what you need very quickly.

With a code file open press:

Ctrl + i

And then begin typing in what you are looking for (it will begin searching on the first letter).

To go to the next result, press Ctrl + i again.

To search upwards, press Ctrl + Shift + i

If you have misspelled, simply press backspace (it doesn't delete your code as you'd first think).

Great for quickly moving around a single file of code.

Visual Studio - convert text to upper case short cut key

In visual studio you can quickly make text upper case, by selecting the text and simply press:


Ctrl + shift + u



It can also be found in the menu edit > advanced > make upper case.

Visual Studio - Find a file auto-complete

In Visual Studio you can find files quickly by using a built in auto-complete feature (particularly useful to find files in large projects worked on in teams where you may not know the complete structure)

1. press: CTRL + /
2. type: of
3. Then start typing in the filename (of the file you wish to open)
4. Select the filename from the drop down box and press enter
5. The file opens (happy developer)

This is tested to work in Visual Studio Professional 2008 / 2010 and Visual Web Developer Express 2010

Shortcut Key for Table Details in Sql Server Management Studio

If you select a table name in the query window of Sql Server Management Studio
and press ALT + F1 it will display the details of that table.

In the background shortcut key will execute sp_help on your behalf, so in this example it executes: sp_help users, which is much quicker than typing it.

I'm running Sql Server Management Studio 2008 R2 (but i'm pretty sure it'll work with earlier versions)