|
Understanding stored procedures
A stored procedure is a reusable database item that contains SQL code that can perform any of the following database operations:
 |
Return one or more recordsets |
|
Insert, update, or delete records |
|
Alter the structure of tables or of the database itself |
A stored procedure can also call another stored procedure, as well as accept input parameters and return multiple values to the calling procedure in the form of output parameters.
A stored procedure is reusable in the sense that you can reuse a single compiled version of the procedure to execute a database operation a number of times. If you know a database task will be executed more than a few times—or the same task will be executed by different applications—using a stored procedure to execute that task can make database operations more efficient.
Note: Microsoft Access databases do not support stored procedures.
The following sections describe how to use the UltraDev rapid application development (RAD) tools to create these pages. ASP developers, see Creating an ASP page that uses a stored procedure. ColdFusion developers, see Creating a ColdFusion page that uses a stored procedure. JSP developers, see Creating a JSP page that uses a stored procedure.
| 
