Database Queries and Visual Database Tools
The document is archived and information here might be outdated

Database Queries and Visual Database Tools

Visual Studio .NET 2003

After a database is designed and populated with data, you can write queries to retrieve information from the database. To help you write queries and views, the Visual Database Tools include the Query and View Designer.

In This Section

Query and View Designer
Explains the panes that compose the Query and View Designer.
Queries and Views
Gives an overview of queries and views.
Comparison of Queries and Views
Discusses similarities and differences between queries and views.
Indexed Views
Describes the advantages and requirements of using views that are indexed in the database for fast access.
Interactions Among Query and View Designer Windows
Describes how modifying a view affects other views or queries.
Interaction Between the Results Pane and the Database
Describes how the database returns result sets to the Query and View Designer.
Supported Query Types
Lists the various types of queries you can graphically create in the Diagram pane and Grid pane of the Query and View Designer.
Structure of Retrieval Queries
Provides links to topics describing how to create complex retrieval queries.
Expressions in Queries
Explains why and how to create expressions in queries.
Parameter Queries
Describes when to use queries that can have different values at different times.
Summary and Grouping Behavior in the Query and View Designer
Explains how to create logically correct aggregate queries.
Using the Query and View Designer with International Data
Gives details on using the Query and View Designer in international applications.

Related Sections

Overview of Visual Database Tools
Provides links to topics describing what's new in Visual Database Tools and how the tools interact with your database.
Database Development and Visual Database Tools
Provides an overview of the tools included and how to manage large database projects.
Developing Database Structure
Gives detailed steps for designing and maintaining database structure through tables, columns, keys, indexes, stored procedures, and more.
Designing Data Retrieval and Manipulation
Provides links to topics with details on how to design queries and views as well as how to modify data.
Reference
Provides links to general reference topics covering queries, operators, search conditions, specific DBMS requirements, user interface reference topics, and error message topics.
Show:
© 2016 Microsoft