Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Applies to: 
SQL Server
The Query and View Designer can help you create and maintain the data retrieval and data manipulation portions of your application.
In this section
| Article | Description |
|---|---|
| Open the Query and View Designer | Provides steps for opening a new or existing query or view in the Query and View Designer. |
| Navigate in the Query and View Designer | Provides a list of key combinations and mouse operations you can use in the Query and View Designer. |
| Query and View Designer Tools | Provides links to articles describing the various components of the Query and View Designer. |
| Types of queries | Lists procedural articles on how to create various types of queries, such as UPDATE, DELETE, and MAKE TABLE queries. |
| Work with data in the Results pane | Describes what you can do with the results returned by a query or view and provides links to procedural articles. |
| Perform Basic Operations with Queries | Lists articles on creating, modifying, running, and copying queries as well as basic articles on sorting, ordering, and printing query results. |
| Specify search criteria | Lists rules and conventions for creating queries, as well as procedures on how to use criteria to get specific results. |
| Query with joins | Lists articles on using joins to query multiple tables, such as how to create outer joins and how to join tables automatically. |
| Query with parameters | Lists articles for creating queries with parameters, which allow a different value to be used each time you run the query. |