by Ray Rankins
IN THIS CHAPTER
A stored procedure is one or more SQL commands stored in a database as an executable object. Stored procedures can be called interactively, from within client application code, from within other stored procedures, and from within triggers. Par-ameters can be passed to and returned from stored procedures to increase their usefulness and flexibility. A stored procedure can also return a number of resultsets and a status code.