Using procedures, triggers, and batches


Procedure and trigger overview
Benefits of procedures and triggers
Introduction to procedures
Introduction to user-defined functions
Introduction to triggers
Introduction to batches
Control statements
The structure of procedures and triggers
Returning results from procedures
Using cursors in procedures and triggers
Errors and warnings in procedures and triggers
Using the EXECUTE IMMEDIATE statement in procedures
Transactions and savepoints in procedures and triggers
Tips for writing procedures
Statements allowed in procedures, triggers, events, and batches
Hiding the contents of procedures, functions, triggers and views