Compartir a través de


How to: Run Queries

When you have finished designing your query, you can run it.

Note

Your computer might show different names or locations for some of the Visual Studio user interface elements in the following instructions. The Visual Studio edition that you have and the settings that you use determine these elements. For more information, see Customizing Development Settings in Visual Studio.

To execute a query

  1. Open or create the query you want to run.

  2. Right-click anywhere in the query window, and select Execute SQL from the shortcut menu.

    –or–

    Press CTRL+R.

If you are creating a Select query, the results of the query appear in the Results pane.

The Query and View Designer returns results to your computer in batches (incrementally) so that you can begin viewing results as soon as possible, and so that you can perform other tasks while the query is underway.

If you are creating an Update, Insert From, Insert Into, Delete, or Make Table query, the Query and View Designer displays a message indicating how many rows were affected by the query.

See Also

Concepts

Working with Data in the Results Pane

Other Resources

Performing Basic Operations with Queries