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.
- 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.
- Provides links to general reference topics covering queries, operators, search conditions, specific DBMS requirements, user interface reference topics, and error message topics.