Redigera

Dela via


Perform Basic Operations with Queries (Visual Database Tools)

Applies to: SQL Server

The following fundamental operations apply to most or all queries.

In This Section

Create Queries (Visual Database Tools)
Provides steps for creating new queries.

Open Queries (Visual Database Tools)
Provides steps for opening existing queries.

Run Queries (Visual Database Tools)
Provides steps for running (or executing) queries.

Stop a Query (Visual Database Tools)
Provides steps for halting a query while it's running.

Save Queries (Visual Database Tools)
Provides steps for saving new or revised queries to a database project.

Verify Queries (Visual Database Tools)
Provides steps for verifying the SQL syntax of a query.

Modify Queries (Visual Database Tools)
Provides steps for opening an existing query for modification.

Delete Queries (Visual Database Tools)
Provides steps for deleting queries from projects.

Copy Queries (Visual Database Tools)
Provides steps for copying the SQL code form one query and pasting it into another.

Rename Queries (Visual Database Tools)
Provides steps for renaming existing queries

Discard Changes Made to Queries (Visual Database Tools)
Provides steps for reverting a query to its last changed state.

Add Tables to Queries (Visual Database Tools)
Provides steps for adding tables and other table-valued objects, such as table-valued functions and views, to queries.

Remove Tables from Queries (Visual Database Tools)
Provides steps for removing tables and other table-valued objects from the structure of a query.

Add Columns to Queries (Visual Database Tools)
Provides steps for adding columns to queries.

Remove Columns from Queries (Visual Database Tools)
Provides steps for removing columns from the structure of a query.

Create Column Aliases (Visual Database Tools)
Provides steps for creating aliases for columns included in a query.

Create Table Aliases (Visual Database Tools)
Provides steps for creating aliases for tables included in a query.

Show Query Properties (Visual Database Tools)
Provides steps for showing properties such as SQL comments, parameter lists, and Top specification.

Create Queries using Something Besides a Table (Visual Database Tools)
Provides steps for creating queries that use table-valued objects, such as table-valued functions and views.

Show Column Names in the Diagram Pane (Visual Database Tools)
Provides steps for customizing how tables and table-valued objects look in the Diagram pane.

Use the Query and View Designer with International Data (Visual Database Tools)
Describes the features the Query and View Designer provide to make working with international data easier.

Reference

Query and View Designer Tools (Visual Database Tools)
Describes the features and capabilities of the Query and View Designer.

Query Properties (Visual Database Tools)
Describes the properties available for queries.

Types of Queries (Visual Database Tools)
Lists topics concerning queries you can work with in Query and View Designer.

Specify Search Criteria (Visual Database Tools)
Lists topics about how to create queries that return the results set you want.

Sort and Group Query Results (Visual Database Tools)
Lists topics about how to create queries that return the results set in the organization you want.

Summarize Query Results (Visual Database Tools)
Lists topics about how to create queries that summarize results of the involved tables and table-valued objects.

Design Queries and Views How-to Topics (Visual Database Tools)
Lists overview topics that provide more detailed links.