You can add the frequently use s.procedure as your keyboard shortcut in your query analyzer(sql 2000) or sql server management studio.
For example, you always need sp_helptext to check existing s.proc in your database, you may type “sp_helptext myStoreProcedure” in your query screen, and hit “F5” to see the outcome.
Now you have faster way to do that, by attach sp_helptext to a keyboard shortcut,
- Go to “Tools -> Options”
- When Options screen pop up, go to “Environment -> Keyboard”.
- Key in “sp_helptext” in the keyboard shortcut you want, refer to image below, in this case is taking “CTRL + F1” shortcut.
- Click OK.
- Restart Query Analyzer/ SQL Server Management Studio to let the changes take effect.
How to use?
Highlighted the s.procedure you want to check, press “CTRL + F1”, this will call up sp_helptext shortcut that you set up in earlier steps, the content of the stored procedure will be shown immediately in Results pane.
You can also add your own s.proc to keyboard shortcut, it never restrict to system s.procedure.
Keywords: Query shortcuts, keyboard shortcuts, Keyboard options, Environment settings, keyboard settings, Customize keyboard shortcuts.