This topic has not yet been rated - Rate this topic

Types of Queries

Visual Studio 2010

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.
How to: Create Full-Text Search Queries: Describes how to create a query that searches a full-text indexed column.
How to: Create Insert Results Queries: Describes how to create a query that inserts the results of a SELECT statement into a table.
How to: Create Insert Values Queries: Describes how to create a query that inserts values into a table.
How to: Create Make Table Queries: Describes how to create a query that creates a new table.
How to: Create Delete Queries: Describes how to create a query that deletes data.
How to: Create UNION Queries: Describes how to create a query that merges the results of two or more SELECT statements into one result set.
How to: Create Update Queries: Describes how to create a query that updates a table.

Reference

Query Properties: Describes the properties available to you when designing queries.
Reference (Visual Database Tools): Provides links to general reference topics covering queries, operators, search conditions, specific DBMS requirements, user interface reference topics, and error message topics.

Related Sections

Designing Queries and Views: Describes how to design and manipulate queries and views.

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Content Add

FAQ