Export (0) Print
Expand All
Expand Minimize

Performing Basic Operations with Queries (Visual Database Tools)

The following fundamental operations apply to most or all queries.

How to: Create Queries (Visual Database Tools)

Provides steps for creating new queries.

How to: Open Queries (Visual Database Tools)

Provides steps for opening existing queries.

How to: Run Queries (Visual Database Tools)

Provides steps for running (or executing) queries.

How to: Stop a Query (Visual Database Tools)

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

How to: Save Queries (Visual Database Tools)

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

How to: Verify Queries (Visual Database Tools)

Provides steps for verifying the SQL syntax of a query.

How to: Modify Queries (Visual Database Tools)

Provides steps for opening an existing query for modification.

How to: Delete Queries (Visual Database Tools)

Provides steps for deleting queries from projects.

How to: Copy Queries (Visual Database Tools)

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

How to: Rename Queries (Visual Database Tools)

Provides steps for renaming existing queries

How to: Discard Changes Made to Queries (Visual Database Tools)

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

How to: 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.

How to: Remove Tables from Queries (Visual Database Tools)

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

How to: Add Columns to Queries (Visual Database Tools)

Provides steps for adding columns to queries.

How to: Remove Columns from Queries (Visual Database Tools)

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

How to: Create Column Aliases (Visual Database Tools)

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

How to: Create Table Aliases (Visual Database Tools)

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

How to: Show Query Properties (Visual Database Tools)

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

How to: 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.

How to: 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.

How to: 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.

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.

Specifying Search Criteria (Visual Database Tools)

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

Sorting and Grouping Query Results (Visual Database Tools)

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

Summarizing Query Results (Visual Database Tools)

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

Designing Queries and Views How-to Topics (Visual Database Tools)

Lists overview topics that provide more detailed links.

Community Additions

ADD
Show:
© 2014 Microsoft