|
Stored Procedures, SP
A stored procedure or short sp
is a collection of SQL statements and also
control-of-flow
statements, containing chains of commands. A stored procedure is stored under a
unique name, making this procedure available for execution on the dataserver.
This makes the stored procedure a self-contained command executing a chain of stored
SQL
and
T-SQL
commands. Using stored procedures, individual commands used for frequent events, can be bundled
and executed in just one call. Additionally,
ASE
safes an
execution plan
after executing the query for the first time which makes running an SP even faster
than executing individual commands.
Types of procedures
System Procedures
User-defined Stored Procedures
See also:
System Procedures.
|
