Adding a new stored procedure

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

  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.