SQL Server Management Studio Keyboard Shortcuts

It can be a bit of a pain when writing long SQL statements when you want to check a table for data. Some people write the full 'Select' statement, some use the side bar, I use a keyboard shortcut to execute a Select statement really quickly.

Creating a keyboard shortcut in Management Studio

1. In SQL Server Management Studio > Tools > Options
2. Open the keyboard tree view on the left side and select query shortcuts
3. Use any of the available slots for the keyboard shortcut 'Select * From'. The below example uses Ctrl+3

The default shortcuts included in Management Studio are really useful when developing as they give vital information about tables but limit the typing and clicking required to get to that information.