The first thing I do after installing SSMS is to pop into the Options dialog and under Environment / Keyboard, assign:
Ctrl+4 “SELECT * FROM ”
Ctrl+5 “SELECT TOP 20 * FROM “
Ctrl+6 “SELECT COUNT(*) FROM “
I find these ‘shortcuts’ very useful when I need to e.g. look up values in a small table, get a feel for the shape of the data in a table etc.
Roll on macros in a later version of SSMS!
Will Alber, SQLsoft