Export (0) Print
Expand All

Performing Basic Operations with Queries

The following fundamental operations apply to most or all queries.

How to: Create Queries

Provides steps for creating new queries.

How to: Open Queries

Provides steps for opening existing queries.

How to: Run Queries

Provides steps for running (or executing) queries.

How to: Stop a Query

Provides steps for halting a query while it's running.

How to: Save Queries

Provides steps for saving new or revised queries to a database project.

How to: Verify Queries

Provides steps for verifying the SQL syntax of a query.

How to: Modify Queries

Provides steps for opening an existing query for modification.

How to: Delete Queries

Provides steps for deleting queries from projects.

How to: Copy Queries

Provides steps for copying the SQL code form one query and pasting it into another.

How to: Rename Queries

Provides steps for renaming existing queries

How to: Discard Changes Made to Queries

Provides steps for reverting a query to its last changed state.

How to: Add Tables to Queries

Provides steps for adding tables and other table-valued objects, such as table-valued functions and views, to queries.

How to: Remove Tables from Queries

Provides steps for removing tables and other table-valued objects from the structure of a query.

How to: Add Columns to Queries

Provides steps for adding columns to queries.

How to: Remove Columns from Queries

Provides steps for removing columns from the structure of a query.

How to: Create Column Aliases

Provides steps for creating aliases for columns included in a query.

How to: Create Table Aliases

Provides steps for creating aliases for tables included in a query.

How to: Show Query Properties

Provides steps for showing properties such as SQL comments, parameter lists, and Top specification.

How to: Create Queries using Something Besides a Table

Provides steps for creating queries that use table-valued objects, such as table-valued functions and views.

How to: Show Column Names in the Diagram Pane

Provides steps for customizing how tables and table-valued objects look in the Diagram pane.

How to: Use the Query and View Designer with International Data

Describes the features the Query and View Designer provide to make working with international data easier.

Query and View Designer Tools

Describes the features and capabilities of the Query and View Designer.

Query Properties

Describes the properties available for queries.

Types of Queries

Lists topics concerning queries you can work with in Query and View Designer.

Specifying Search Criteria

Lists topics about how to create queries that return the results set you want.

Sorting and Grouping Query Results

Lists topics about how to create queries that return the results set in the organization you want.

Summarizing Query Results

Lists topics about how to create queries that summarize results of the involved tables and table-valued objects.

Designing Queries and Views

Lists overview topics that provide more detailed links.

Community Additions

ADD
Show:
© 2014 Microsoft