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.
Atsauksmes
https://aka.ms/ContentUserFeedback.
Drīzumā: 2024. gada laikā mēs pakāpeniski pārtrauksim izmantot “GitHub problēmas” kā atsauksmju par saturu mehānismu un aizstāsim to ar jaunu atsauksmju sistēmu. Papildinformāciju skatiet:Iesniegt un skatīt atsauksmes par