Saturday, December 14, 2013

How do I bring up the query designer in SQL Server 2012 Express?

Query Designer is a Graphic User Interface.

It is quite easy.
There are two ways you can do it.

Step 1. Open a Query pane by right clicking either the Server Node or right clicking one
of the user databases as shown.
 SERVER NODE


USER DATABASE NODE

Step 2. Once the query pane is open, click inside the query pane. The main menu
changes
to display the Query menu item as shown.

 


Step 3.Click Query menu item to display a drop-down list and click on Design Query in Editor or Ctrl+Shift+Q
 

This should bring up the designer as shown.


Step 3b. Another way is to right click inside the query pane and choose Design Query in Editor as before.

 

No comments: