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

How to Install SQL Server 2000

How To

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

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

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