Using Stored Procedures

A stored procedure is a named collection of SQL statements or control-of-flow language. You can create stored procedures for commonly used functions and to increase performance. Adaptive Server also provides system procedures to perform administrative tasks and to update the system tables.

You can also create and use extended stored procedures to call procedural language functions from Adaptive Server. See Chapter 15, "Using Extended Stored Procedures."

How stored procedures work

Examples of creating and using stored procedures

Stored procedures and permissions

Stored Procedures and Performance

Creating and executing stored procedures

Parameters

Default parameters

Using more than one parameter

Procedure groups

Using with recompile in create procedure

Using with recompile in execute

Nesting procedures within procedures

Using temporary tables in stored procedures

Setting options in stored procedures

After creating a stored procedure

Executing stored procedures

Returning information from stored procedures

Return status

Checking roles in procedures

Return parameters

Restrictions associated with stored procedures

Qualifying names inside procedures

Renaming stored procedures

Renaming objects referenced by procedures

Using stored procedures as security mechanisms

Dropping stored procedures

System procedures

Executing system procedures

Permissions on system procedures

Types of system procedures

Other Sybase-supplied procedures

Getting information about stored procedures

Getting a report with sp_help

Viewing the source text of a procedure with sp_helptext

Identifying dependent objects with sp_depends

Identifying permissions with sp_helprotect


	Expand Search