To use the Query Designer in SQL Server:

  1. Open a new query by clicking New Query on the toolbar
  2. Open the Query Designer by selecting Query > Design Query in Editor... from the top menu
  3. Add the tables you want to run the query against
  4. Build the criteria for your query then click OK

The query will appear in the query window. To run the query, click ! Execute or press F5

Below are screenshots for the above steps.

Open a New Query

Open a new query by clicking New Query on the toolbar

Screenshot of the SSMS with the New Query button highlighted (SQL Server 2014)

The SSMS with the New Query button highlighted.

Open the Query Designer

Open the Query Designer by selecting Query > Design Query in Editor... from the top menu:

Screenshot of dropdown menu for Query Designer in SQL Server 2014.

Selecting the “Design Query in Editor” will get you to the Query Designer.

Select the Tables

Select the tables you want to run the query against, click Add, and close the box by clicking Close:

Screenshot of the Add Table dialog in SQL Server 2014

The “Add Table” dialog box for selecting the tables to use in your query.

The Query Designer

Build the criteria for your query then click OK:

Screenshot of the Query Designer

The Query Designer allows you to build complex queries within a graphical interface.

To use the Query Designer, select the column/s you want to display in your query by checking the checkbox next to the column name. In the middle pane, you can deselect an Output checkbox to hide that field from being displayed when the query is run (but the field will still be involved in the query). Add a value under Filter to narrow the results down to only those you’re interested in.

Run the Query

Once you click the OK button, the query will be added to your workspace. You can then run the query from the workspace, as you would with any other query.

Screenshot of workspace with query in SQL Server 2014

Once you’ve built your query in the Query Designer and clicked “OK”, it is added to your workspace for you to run.