Stored Procedures

One of the most important Transact-SQL extensions is the ability to create stored procedures. A stored procedure is a collection of SQL statements and optional control-of-flow statements stored under a name.

The creator of a stored procedure 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. Since the execution plan is saved after stored procedures are run, stored procedures can subsequently run much faster than standalone statements.

Stored procedures supplied by SAP ASE, called system procedures, aid in SAP ASE system administration.

You can execute stored procedures on remote servers. All Transact-SQL extensions support return values from stored procedures, user-defined return statuses from stored procedures, and the ability to pass parameters from a procedure to its caller.

Related concepts
Stored Procedures