How to execute a stored procedure with an input parameter (Enterprise Manager)

previous page next page

How To

To execute a stored procedure with an input parameter using the Execute SQL task

In the Execute SQL Task Properties dialog box, in the SQL statement box, type the parameterized SQL stored procedure statement. For example:
```
exec byRoyalty ?
```
Click Parameters, click the Input Parameters tab, and then assign a global variable and its value to the parameter.

previous page start next page