The Stored Procedures tutorial demonstrates how to use Sybase WorkSpace to view, create, and run stored procedures for an Adaptive Server Enterprise database.
A stored procedure is a collection of SQL statements and optional control-of-flow statements stored under a user-specified name. When you create a stored procedure, you can also define parameters to be supplied when the stored procedure is executed.
The ability to write your own stored procedures greatly enhances the power, efficiency, and flexibility of the SQL database language. Because Adaptive Server Enterprise saves the execution plan after running the stored procedures, stored procedures can subsequently run much faster than standalone statements.
For additional background information on the features or concepts for Adaptive Server Enterprise, Sybase WorkSpace, or the Eclipse IDE, see “Related documents”.
