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.
-
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.
Other Resources
EXECUTE (Transact-SQL)
CREATE PROCEDURE (Transact-SQL)
Stored Procedures (Database Engine)
Help and Information
Getting SQL Server 2008 Assistance