Search This Blog

Wednesday, July 20, 2011

Define Keyboard Shortcuts in SQL Server Management Studio to Simplfy T-SQL Commands

Did you get tired of coding the same statement like "SELECT * FROM ...", or "sp_helptext ...", or "sp_help ...", etc ?
Why don't you use SQL Server Management Studio Query Window keyboard shortcuts?
Just highlight the SQL Server object name on Query Editor window and press shortcut keys.
Follow the following menu options in Microsoft SQL Server Management Studio IDE.
Tools > Options...
When Options configuration dialog screen is displayed drill-through Environment > Keyboard
SQL Server professionals will see a screen similar to shown below. The default keyboard shortcuts defined are :
Alt+F1 for sp_help,
Ctrl+1 for sp_who, and
Ctrl+2 for sp_lock
SQL Server Management Studio Options for keyboard shortcuts
Note : One important thing about this keyboard shortcuts is if you make a change on the list you must open a new Query Editor window to see the changes affected.

No comments:

Post a Comment