Stored Procedure Tutorial

This tutorial will show you how to easily manage your Stored Procedures using Database Schema Designer.

• Add / Edit a Stored Procedure

  1. If Adding a new Stored Procedure:

     There are a number of methods to create a new Stored Procedure.   Choose the one you are most comfortable with:

     • Open Manage Stored Procedures screen and click the "Add" button.   See Manage Schema Objects Tutorial.
     • Click the "+P" icon on the main screens toolbar.
       
     • Select "Insert -> Stored Procedure" from the main menu.
       
     • Use the keyboard command "Ctrl + R" on the main screen.
     • To create a new Stored Procedure using a selected Table and the Stored Procedure Wizard:
       Select a Table and use the keyboard command "Ctrl + Shift + R".   See the Stored Procedure Wizard section on this page.

     If Editing an existing Stored Procedure:

     There are a number of methods to edit an existing Stored Procedure.   Choose the one you are most comfortable with:

     • Open Manage Stored Procedure screen and click the "Edit" button with the Stored Procedure selected.   See Manage Schema Objects Tutorial.
     • Double Click the Stored Procedure in the Schema Explorer.
     • Right Click the Stored Procedure in the Schema Explorer and select Properties.
       
  2. Editing Stored Procedure Properties
     • Type the SQL that comprises your Stored Procedure.
       
       - OR -
       Use the Stored Procedure Wizard
     • Click the    button to log in to your Server and validate the Stored Procedure's syntax.  (Not Required)
     • There are a few keyboard shortcuts available for screens that have direct SQL entry.   See SQL Quick Tips
  3. Click OK to submit your changes.
     - OR -
     Click Cancel to discard your settings.
• Stored Procedure Wizard

  The Wizard will help you create the 3 most standard Stored Procedures with only a few clicks:   Adding a record, editing a record and deleting a record.  

  • Click the Wizard Button at the top of the form - OR - press "Ctrl+W".
    
  • Select a Table from the drop down list.
    
  • Select Add, Edit or Delete depending upon what you would like the Stored Procedure to do.   Add a record, edit a record, or delete a record in the Database.
    
  • Check the Column(s) that uniquely identify the Table.   Primary Key and Identity Columns will be selected automatically.
    
  • Click OK to submit your changes.
    - OR -
    Click Cancel to discard your settings.
  • 
    * Any text that existed before using the Wizard will be commented out.
• Delete a Stored Procedure

  There are 2 methods to delete a Stored Procedure from the Schema.  Choose the one you are most comfortable with:

  • Open the Manage Stored Procedures screen and click Delete with the Stored Procedure selected.   See Manage Schema Objects Tutorial.
  • Using the Schema Explorer, Right Click the Stored Procedure and select Delete.