Inbuilt Query Designer Tool In SQL Server 2008

This article describes how to design query in SQL Server editor. Using this tool we build SELECT statements. This is as add-in to the query window provides a means to include tables from a specific database to the designer. You can see a visual representation of the tables with the referential integrity all in one screen, then build the needed query with Joins, WHERE and or ORDER BY clauses.

Lets see following steps to build queries using SQL Server Management Studio Query Designer.

Step 1

Open SQL Server Management Studio and connect to database engine.

Step 2

To build a query with the query designer. Select Query-> Design Query in Editor.

Step 3

Add the user defined tables you want to run the query against. Select the columns you want to use in the query, sort type, sort order etc. You can see query is automatically generated according to requirement. Click OK.

Step 4

Generated query will load into the original query editor work space where  run it as you would any other query.

Using Query Designer, you can perform:

• You can create select queries easily using mouse. There is no need to write whole query.
• View query execution statistics with query profiler tool.
• Visually create INSERT, UPDATE and DELETE queries.
• You can perform step by step complex queries with help of Wrap to Sub query function.