Execute Procedure Dialog Box

Use the Execute Procedure dialog box to specify parameter values and execute a stored procedure.

Options

Procedures

Select the stored procedure to be executed.

Parameters

List the parameters defined for the stored procedure.

Data type

Show the data type of the selected parameter.

Direction

Show whether the selected parameter is an input or output parameter.

Value

Specify a value for the selected parameter.

Set to null

Specify a null value for the selected parameter.

Execute

Execute the stored procedure using the specified values.

Copy

Using the specified values, produce the Transact-SQL statements used to invoke the stored procedure, and copy those statements to the clipboard.