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.
Σχόλια
https://aka.ms/ContentUserFeedback.
Σύντομα διαθέσιμα: Καθ' όλη τη διάρκεια του 2024 θα καταργήσουμε σταδιακά τα ζητήματα GitHub ως μηχανισμό ανάδρασης για το περιεχόμενο και θα το αντικαταστήσουμε με ένα νέο σύστημα ανάδρασης. Για περισσότερες πληροφορίες, ανατρέξτε στο θέμα:Υποβολή και προβολή σχολίων για