Execute Procedure Dialog Box

Applies To: Windows Server 2008, Windows Server 2008 R2

Use the Execute Procedure dialog box to specify the stored procedure parameters for a selected procedure, and to execute the stored procedure.

UI Elements

Element Name Description

Parameter

Displays the parameter(s) that the stored procedure requires. This value is read-only.

Data Type

Displays the data type for the corresponding parameter, for example, varchar or bit. This value is read-only.

Output Parameter

Displays Yes if the parameter is an output parameter; displays No if the parameter is an input parameter. Parameters that have the text, ntext, or image data types can be used as output parameters. This value is read-only.

Pass Null Value

Select this option to specify a null value for the parameter. The stored procedure may or may not run successfully depending on whether the parameter accepts null values.

Value

Type a value for the corresponding parameter.