Adding a new stored procedure

You can add a new stored procedure to a stub by using the Add wizard.

Procedure

  1. In the Name field on the Add Stored Procedure window of the Add wizard, enter the name of the new stored procedure.
    Note: When adding a stored procedure to a database stub, synonyms are not displayed for selection in the Add Stored Procedure window. However, you can add a query in the Add Query window and then use that query to learn from the database, which will import the synonym (if it exists) into the database stub.
  2. Optional: Click the plus button on the Parameters toolbar to add one or more new input, input/output, or output parameters to the new stored procedure. For example, you could use an input parameter to help find a match.
  3. Click Next.
  4. Click Finish to close the Add wizard.
Feedback