Types of Queries (Visual Database Tools)

Applies to: SQL Server

The Query and View Designer provides built-in features for some query types--Select, Insert Results, Insert Values, Update, Delete, and Make Table--and also supports UNION, Full-text search, and CASE expression queries.

In This Section

Supported Query Types (Visual Database Tools)
Describes the query types you can use with the Query and View Designer.

Create Full-Text Search Queries (Visual Database Tools)
Describes how to create a query that searches a full-text indexed column.

Create Insert Results Queries (Visual Database Tools)
Describes how to create a query that inserts the results of a SELECT statement into a table.

Create Insert Values Queries (Visual Database Tools)
Describes how to create a query that inserts values into a table.

Create Make Table Queries (Visual Database Tools)
Describes how to create a query that creates a new table.

Create Delete Queries (Visual Database Tools)
Describes how to create a query that deletes data.

Create UNION Queries (Visual Database Tools)
Describes how to create a query that merges the results of two or more SELECT statements into one result set.

Create Update Queries (Visual Database Tools)
Describes how to create a query that updates a table.

Reference

Query Properties (Visual Database Tools)
Describes the properties available to you when designing queries.

Related Sections

Design Queries and Views How-to Topics (Visual Database Tools)
Describes how to design and manipulate queries and views.