Creating General Purpose Queries

Visual Database Tools

Visual Database Tools

Creating General Purpose Queries

In many instances, it is useful to create a query that you can reuse many times in your applications with different input each time. In this section you will find information about how to create parameter queries for these general purposes.

To See
Learn about general-purpose queries Parameter Queries
Create a query using unnamed parameters Creating a Query with Unnamed Parameters
Specify names for the parameters in your query to help distinguish multiple parameters Creating a Query with Named Parameters
Mark a name as a parameter instead of a string of literal characters Specifying Parameter Marker Characters