To Create a Stored Procedure:

  1. Click the object Stored Procedure in the tree. The Stored Procedures page will appear.

  2. Click Create. The Introduction window of the Create Stored Procedure wizard will open.

  3. You can choose to type a stored procedure into the statement field, or import a stored procedure by clicking Import.

  4. Clicking Import will open the Open window. Files can be imported from any source, including the SPDIR directory of other databases on the server or network drives. Select the desired file by typing in the path in the File name field, or browse through the directory tree until the correct path is found.

     

  5. Click Open to open the file.

  6. The Create Stored Procedure window will reappear as in the example below if the imported file contains properly formatted (ASCII) text, or if you choose to manually enter the code. Click Save As to store the stored procedure to another location, or click OK to compile and store the stored procedure in the database.

  7. If the Stored Procedure compiles correctly, the following message will appear.

  8. Click OK.


Related topic:

Creating a Stored Procedure
Executing a Stored Procedure

Dropping a Stored Procedure

Granting Privileges on Stored Procedure