Use parameters

Last modified: March 12, 2024

A parameter is a placeholder for a variable that contains a value of some type that is passed to a database server along with the SQL text at the query execution time. Also, a parameter can hold values returned by a server after the query or stored procedure execution.

You can benefit from using parameters in the following situations:

• When you execute a query multiple times with different input values
• When you debug a query from your application code

Add parameters to a query

Parameters are declared using ?.

For example:

SELECT
  *
FROM film
WHERE title = ?
AND length >= ?

If you execute the query, the Edit Parameters window appears where you can enter the required parameters, for example:

Click OK to save the changes and see the result. The query returned the record with the specified parameters:

Modify parameter values and types

When you run a query that contains parameters with empty values, you will automatically be prompted to initialize them.

To modify parameter values and types, select Edit Parameters on the toolbar or press F8. In the Edit Parameters window that opens, set parameters’ type, value, and other properties.

Note

When you execute a query with preset parameter values, you will not be automatically prompted to edit them. To edit parameters, press F8 or select Edit Parameters on the toolbar.