Windows Management and Toolbar Keyboard Shortcuts

 

Action	Standard	Sql Server 2000/2005
Close the current MDI child window	CTRL+F4	CTRL+F4
Print	CTRL+P	CTRL+P
Exit	ALT+F4	ALT+F4
Toggle full screen mode	SHIFT+ALT+ENTER	SHIFT+ALT+ENTER
Close the current tool window	SHIFT+ESC	SHIFT+ESC
Cycle through the next MDI child windows	CTRL+TAB	CTRL+TAB
Cycle through the previous MDI child windows	CTRL+SHIFT+TAB	CTRL+SHIFT+TAB
Move to the current tool window toolbar	SHIFT+ALT	No equivalent
Move to the next tool window	ALT+F6	ALT+F6
Move to the previously selected window	SHIFT+ALT+F6	SHIFT+ALT+F6
Opens a new query editor window	No equivalent	CTRL+O
Display Object Explorer	F8	F8
Display Registered Servers	CTRL+ALT+R	No equivalent
Display Template Explorer	CTRL+ALT+T	CTRL+ALT+T
Display Solution Explorer	CTRL+ALT+L	CTRL+ALT+L
Display the Summary Window	F7	F7
Display the Properties Window	F4	F4
Display the Toolbox	CTRL+ALT+X	CTRL+ALT+X
Display the Bookmarks Window	CTRL+K, CTRL+W	No equivalent
Display the Browser Window	CTRL_ALT+R	CTRL_ALT+R

SQL Server Shortcut Keys

 

Description

Shortcuts

Clear all bookmarks CTRL+SHIFT+F2 Save All CTRL+SHIFT+S Go To line CTRL+G Display Solution Explorer CTRL+ALT+L Previous Child Window CTRL+SHIFT+TAB Next Child Window CTRL+TAB Full Screen Mode SHIFT+ALT+ENTER Comment a Text CTRL+K, CTRL+C Uncomment a Text CTRL+K,CTRL+U Close a menu or Dialog Box ESC Display Query Designer CTRL+SHIFT+Q Display Registered Server CTRL+ALT+G Insert or remove a bookmark (toggle). CTRL+F2 Move to next bookmark. F2 Move to previous bookmark. SHIFT+F2 Cancel a query. ALT+BREAK Connect or Open File. CTRL+O Disconnect Connections. CTRL+F4 Disconnect Connection and close child window. CTRL+F4 Database object information. ALT+F1 Clear the active Editor pane. CTRL+SHIFT+ DEL Comment out code. CTRL+SHIFT+C Copy. You can also use CTRL+INSERT. CTRL+C Cut. You can also use SHIFT+DEL. CTRL+X Decrease indent. SHIFT+TAB Delete through the end of a line in the Editor pane. CTRL+DEL Find. CTRL+F Go to a line number. CTRL+G Increase indent. TAB Make selection lowercase. CTRL+SHIFT+L Make selection uppercase. CTRL+SHIFT+U Paste. You can also use SHIFT+INSERT. CTRL+V Remove comments. CTRL+SHIFT+R Repeat last search or find next. F3 Replace. CTRL+H Select all. CTRL+A Undo. CTRL+Z Execute a query. You can also use CTRL+E. F5 Help for SQL Query Analyzer. F1 Help for the selected Transact-SQL statement. SHIFT+F1 Switch between query and result panes. F6 Switch panes. SHIFT+F6 Window Selector. CTRL+W New Query window or Create new file. CTRL+N Object Explorer (show/hide). F8 Object Search. F4 Parse the query and check syntax. CTRL+F5 Print. CTRL+P Display results in grid format. CTRL+D Display results in text format. CTRL+T Move the splitter. CTRL+B Save results to file. CTRL+SHIFT+F Show Results pane (toggle). CTRL+R Save. CTRL+S Insert a template. CTRL+SHIFT+INSERT Replace template parameters. CTRL+SHIFT+M Display estimated execution plan. CTRL+L Display execution plan (toggle ON/OFF). CTRL+K Index Tuning Wizard. CTRL+I Show client statistics CTRL+SHIFT+S Show server trace. CTRL+SHIFT+T Use database CTRL+U Cancel Executing Query ALT+BREAK Toggle Between Query and Results Pan F6 List members in Intelligence CTRL+SPACE Display Context Menu SHIFT+F10

MS SQL Server Interview Questions. Part-1

 1. How to get 1st Highest Salary without using any Functions?

Solution: Suppose a Table [Emp] exists is DB with following fields.

SELECT 
    TOP 1 EMPID, EMPNAME, SALARY 
FROM 
    EMP 
ORDER BY 

    SALARY DESC 

2. Create table without using CREATE command?

Solution: SELECT * INTO NEW_Table_Name FROM Table_Name
Suppose want to create new table [Emp_Backup] from [Emp] table containing all data.

SELECT * INTO Emp_Backup FROM Emp

However instead of selecting all columns (*) for selected fields also a new table can be created.
WHERE clause can be used to create new table for specific condition.

Menu Activation Keyboard Shortcuts

 

Action	Standard	Sql Server 2000/2005/2008/upper version
Move to the SQL Server Management Studio menu bar	ALT	ALT
Activate the menu for a tool component	ALT+HYPHEN	ALT+HYPHEN
Display the context menu	SHIFT+F10	SHIFT+F10
Display the New File dialog box to create a file	CTRL+N	No equivalent
Display the New Project dialog box to create a new project	CTRL+SHIFT+N	CTRL+SHIFT+N
Display the Open File dialog box to open an existing file	CTRL+O	CTRL+SHIFT+INS
Display the Open Project dialog box to open an existing project	CTRL+SHIFT+O	CTRL+SHIFT+O
Display the Add New Item dialog box to add a new file to the current project	CTRL+SHIFT+A	CTRL+SHIFT+A
Display the Add Existing Item dialog box to add an existing file to the current project	ALT+SHIFT+A	No equivalent
Display the Query Designer	CTRL+SHIFT+Q	CTRL+SHIFT+Q
Close a menu or dialog box, canceling the action	ESC	ESC