Summary

In this chapter, you've explored using SQL stored procedures. You've learned about the following:

• Creating and executing stored procedures

• Using input and output parameters

• Coding in procedures with loops, conditional statements, and variables

• Working with cursors

• Returning result sets from a stored procedure

• Error handling in stored procedures

You'll be using stored procedures a lot in the rest of the book, and you'll build on these techniques. In the next chapter, you'll look at SQL transactions, which allow you to treat multiple statements as a single unit.