هذه هي اختصارات لوحة المفاتيح لـ Query Analyzer
Bookmarks: Clear all bookmarks. CTRL-SHIFT-F2 Bookmarks: Insert or remove a bookmark (toggle). CTRL+F2 Bookmarks: Move to next bookmark. F2 Bookmarks: Move to previous bookmark. SHIFT+F2 Cancel a query. ALT+BREAK Connections: Connect. CTRL+O Connections: Disconnect. CTRL+F4 Connections: Disconnect and close child window. CTRL+F4 Database object information. ALT+F1 Editing: Clear the active Editor pane. CTRL+SHIFT+ DEL Editing: Comment out code. CTRL+SHIFT+C Editing: Copy. You can also use CTRL+INSERT. CTRL+C Editing: Cut. You can also use SHIFT+DEL. CTRL+X Editing: Decrease indent. SHIFT+TAB Editing: Delete through the end of a line in the Editor pane. CTRL+DEL Editing: Find. CTRL+F Editing: Go to a line number. CTRL+G Editing: Increase indent. TAB Editing: Make selection lowercase. CTRL+SHIFT+L Editing: Make selection uppercase. CTRL+SHIFT+U Editing: Paste. You can also use SHIFT+INSERT. CTRL+V Editing: Remove comments. CTRL+SHIFT+R Editing: Repeat last search or find next. F3 Editing: Replace. CTRL+H Editing: Select all. CTRL+A Editing: Undo. CTRL+Z Execute a query. You can also use CTRL+E (for backward compatibility). F5 Help for SQL Query Analyzer. F1 Help for the selected Transact-SQL statement. SHIFT+F1 Navigation: Switch between query and result panes. F6 Navigation: Switch panes. Shift+F6 Navigation: Window Selector. CTRL+W New Query window. CTRL+N Object Browser (show/hide). F8 Object Search. F4 Parse the query and check syntax. CTRL+F5 Print. CTRL+P Results: Display results in grid format. CTRL+D Results: Display results in text format. CTRL+T Results: Move the splitter. CTRL+B Results: Save results to file. CTRL+SHIFT+F Results: Show Results pane (toggle). CTRL+R Save. CTRL+S Templates: Insert a template. CTRL+SHIFT+INSERT Templates: Replace template parameters. CTRL+SHIFT+M Tuning: Display estimated execution plan. CTRL+L Tuning: Display execution plan (toggle ON/OFF). CTRL+K Tuning: Index Tuning Wizard. CTRL+I Tuning: Show client statistics CTRL+SHIFT+S Tuning: Show server trace. CTRL+SHIFT+T Use database. CTRL+U
و هذه ايضا معلومة مفيدة
Create Your Own Custom Shortcuts in Query Analyzer
Query Analyzer provides up to 12 keyboard shortcuts for quickly executing stored procedures in Query Analyzer. SQL Server provides three predefined shortcuts:
Alt+F1—sp_help
Ctrl+1—sp_who
Ctrl+2—sp_lock
You can view or modify these shortcuts, or even add your own by selecting the Customize option from the Tools menu. On the Custom tab, you can enter the name of the stored procedure in the Stored Procedure column next to the desired keyboard shortcut you want to use to execute that stored procedure. You might want to add your frequently executed procedures to the Custom menu to save you the trouble of having to type them every time you want to run them.
Here's a bonus tip: if you have a word, data value, or comma-separated list of values highlighted when you invoke a keyboard shortcut, Query Analyzer passes the highlighted value(s) as parameters to the associated stored procedure.