How to: Create Queries (Visual Database Tools)

Queries allow you to retrieve data from the tables and views in your database. You create and work with queries in Query and View Designer, which is composed of four panes: the Diagram Pane, the SQL Pane, the Criteria Pane, and the Results Pane.

To create a new query

  1. In Object Explorer, expand the Tables node for the database you want to query. Right-click the table you want to query and click Open Table.

  2. To add more tables to the query, on the Query Designer menu, select Add Table.

    Note

    If you do not see the Diagram, SQL, Criteria, or Results panes, from the Query Designer menu, point to Pane and click the pane you want to open.

  3. In the Add Table dialog box, select the tables you want to query and click Add for each one.

  4. Once you have added all the tables you want to query, click Close.

    To add more tables later, right-click the open space in the Diagram pane and from the shortcut menu click Add Table.

  5. In the Diagram Pane, check the boxes in the table-valued objects for each column you want to query.

  6. From the Query Designer menu, choose Execute SQL to run your query.

To further refine your query, you can change the SQL code in the SQL Pane or choose options such as sort order and column aliases in the Criteria Pane.

See Also

Tasks

How to: Save Queries (Visual Database Tools)

Other Resources

Types of Queries (Visual Database Tools)
Specifying Search Criteria (Visual Database Tools)
Summarizing Query Results (Visual Database Tools)
Performing Basic Operations with Queries (Visual Database Tools)

Help and Information

Getting SQL Server 2005 Assistance