• Article

Specify Values for Template Parameters

Use the Specify Values for Template Parameters dialog box to specify values for parameters in stored procedures or functions. To open this dialog box, on the Query menu, click Specify Values for Template Parameters.

Complete the grid with the value for any parameters. The parameter name and data type cannot be changed in this dialog box. When you click OK, the values you provide replace the parameters in the Query Editor. To use this dialog box, you must have parameters in your script enclosed in angle brackets (< >) in the format <parameter_name, data_type, default_value>.

  • Parameter
    Lists the parameters in a stored procedure or function. This field is read-only.

  • Type
    The data type of the parameter in the template. This field is read-only. To change the data type, change the parameter in the template.

  • Value
    Specify a value for the selected parameter.

    Security noteSecurity Note

    In some circumstances, credentials may be echoed to the user's screen during execution.