| Home | Previous Lesson: Deleting Through a Cursor Next Lesson: SQL Anywhere Stored Procedures |
Stored procedures are collections of SQL statements, which are stored in the database. When a stored procedure is first run, an execution plan is prepared, which makes any subsequent execution of the procedure fast. Also, since the stored procedure is stored in the database, the client application only needs to send the stored procedure name and parameters if any, for the procedure to run. This reduces network traffic and makes the execution faster.
If the database back-end supports stored procedures, you can execute them from a PowerBuilder application's script. Both SQL Anywhere and SQL Server support stored procedures.
Let's look at the syntax involved in each.
| Home | Previous Lesson: Deleting Through a Cursor Next Lesson: SQL Anywhere Stored Procedures |