|
Thursday, 29 December 2011 11:55 |
|
Alt+F1: sp_help Alt+X: execute a query Ctrl+C or Ctrl+X: without selecting anything it will copy/cut the entire row Ctrl+Shift+Delete: delete all from the current tab Ctrl+K, K: creates a bookmark Ctrl+up/down arrow key: scroll Ctrl+R: show/hide results pane Ctrl+T: set results to text Ctrl+D: set results to grid Ctrl+K, C: comment out the selected text Ctrl+K, C: uncomment the selected text Ctrl+N: new query Alt, Q, C, H: change query connection Alt, Q, C, C: connect to server Alt, Q, M: enable/disable SQLCMD mode Ctrl+Tab: switch between query tabs
Ctrl+F1: sp_helptext
CTR+1 : sp_who CTRL+2 : sp_lock Ctrl+3: sp_columns Ctrl+4: sp_tables Ctrl+5: sp_stored_procedures Ctrl+6: sp_helpindex Ctrl+7: sp_spaceused
CTRL-SHIFT-F2 -- Clear all bookmarks. CTRL+F2 -- Insert or remove a bookmark (toggle). F2 -- Move to next bookmark. SHIFT+F2 -- Move to previous bookmark. ALT+BREAK -- Cancel a query. CTRL+O -- Connect. CTRL+F4 -- Disconnect. CTRL+F4 -- Disconnect and close child window. ALT+F1 -- Database object information. CTRL+SHIFT+DEL -- Clear the active Editor pane. CTRL+SHIFT+C -- Comment out code. CTRL+C or Ctrl+Insert -- Copy CTRL+X or Shift+Del -- Cut SHIFT+TAB -- Decrease indent. CTRL+DEL -- Delete through the end of a line in the Editor pane. CTRL+F -- Find. CTRL+G -- Go to a line number. TAB -- Increase indent. CTRL+SHIFT+L -- Make selection lowercase. CTRL+SHIFT+U -- Make selection uppercase. CTRL+V or Shift+Insert -- Paste. CTRL+SHIFT+R -- Remove comments. F3 -- Repeat last search or find next. CTRL+H -- Replace. CTRL+A -- Select all. CTRL+Z -- Undo. F5 or Ctrl + E -- Execute a query. F1 -- Help for Query Analyzer. SHIFT+F1 -- Help for the selected Transact-SQL statement. F6 -- Switch between query and result panes. Shift+F6 -- Switch panes. CTRL+W -- Window Selector. CTRL+N -- New Query window. F8 -- Object Browser (show/hide). F4 -- Object Search. CTRL+F5 -- Parse the query and check syntax.
|