Thursday, April 10, 2008

SQL Server 2000 Query Analyzer Shortcut







































































































































































































ShortcutFunction ShortcutFunction
ALT+BREAKCancel a query CTRL+SHIFT+F2Clear all bookmarks
ALT+F1Database object information (Sp_Help) CTRL+SHIFT+INSERTInsert a template
ALT+F4Exit CTRL+SHIFT+LMake selection lowercase
ISQLWTo start query analyzer from RUN window CTRL+SHIFT+MReplace template parameters
CTRL+BMove the splitter CTRL+SHIFT+POpen
SQLWbTo start management studio from command window CTRL+SHIFT+RRemove comment
CTRL+DDisplay results in grid format CTRL+SHIFT+SShow client statistics
CTRL+DeleteDelete through the end of the line CTRL+SHIFT+TShow server trace
CTRL+EExecute query CTRL+SHIFT+UMake selection uppercase
CTRL+FFind CTRL+TDisplay results in text format
CTRL+F2Insert/remove bookmark CTRL+UChange database
CTRL+F4Disconnect CTRL+VPaste
CTRL+F5Parse query and check syntax CTRL+WWindow selector
CTRL+GGo to line CTRL+XDelete
CTRL+HReplace CTRL+ZUndo
CTRL+IIndex Tuning Wizard F1Help for Query Analyzer
CTRL+KDisplay/hide execution plan F2Move to next bookmark
CTRL+LDisplay execution plan F3Repeat last search
CTRL+NNew query window F4Object Search
CTRL+OConnect F5Execute a query
CTRL+PPrint F6Switch between query and result panes
CTRL+RShow/Hide results pane F8Show/hide Object Browser
CTRL+SSave SHIFT+F1Transact-SQL help
CTRL+SHIFT+0Show options SHIFT+F2Move to previous bookmark
CTRL+SHIFT+CComment out code SHIFT+TABDecrease indent
CTRL+SHIFT+DELClear the active Editor pane SHIFT+F6Switch panes
CTRL+SHIFT+FSave results to file TABIncrease indent

No comments:

Post a Comment