Execute Procedure (General Page)

Use the Execute Procedure dialog box to execute a stored procedure in Object Explorer. If the procedure has parameters, they appear in the grid. Complete input parameters by type the parameter values in the Value box for each parameter.

Options

  • Parameter
    Indicates the name of the parameter.
  • Data Type
    Indicates the data type of the parameter.
  • Output Parameter
    Indicates if this is an output parameter.
  • Pass Null Value
    Pass a NULL as the value of the parameter.
  • Value
    Type the value for the parameter when calling the procedure.

See Also

Other Resources

EXECUTE (Transact-SQL)
CREATE PROCEDURE (Transact-SQL)
Using Variables and Parameters (Database Engine)
Stored Procedures (Database Engine)

Help and Information

Getting SQL Server 2005 Assistance