SQL Script Procedures and Structure

The following sections cover the syntactic details of a procedure.

Basic Structure of a SQL Script Procedure
SQL Script Procedure Header
Compound Statements
Independent Transactions
Compensating Transactions
Exceptions