Chapter 5 Building Triggers and Procedures
You can define stored procedures and functions for any DBMS that supports them.
A stored procedure is a precompiled collection of SQL statements stored under a name and processed as a unit. Stored procedures are stored within a database; can be executed with one call from an application; and allow user-declared variables, conditional execution, and other programming features.
The use of stored procedures can be helpful in controlling access to data (end-users may enter or change data but do not write procedures), preserving data integrity (information is entered in a consistent manner), and improving productivity (statements in a stored procedure only need to be written one time).
A user-defined function is a form of procedure that returns a value to the calling environment for use in queries and other SQL statements.
| Copyright (C) 2005. Sybase Inc. All rights reserved. |
| |