|
To create a new stored procedure is a very easy process. Just
follow these steps:
From the top menu, click the button New Stored Procedure,
then when a list drops down, select one of the following types of stored
procedures to create (SELECT,UPDATE,INSERT and DELETE).
To create a SELECT stored procedure, the following window will appear, where
you can visually build the SQL statement you want, test it to see it returns
data, then click NEXT. see image below:
-
For the INSERT, UPDATE and DELETE stored procedures, a normal wizard will
appear, where you select the table, and the fields you want to pass parameters
to. See image below:
-
When you are completed, click the Finish button, and a window
(shown below) will appear, asking you to give the stored procedure a name.
Thats all it takes to create a stored procedure, with no coding!!
|
|