You should be aware of some special topics when writing your stored procedures. In some cases, understanding these topics can help you provide a more efficient solution to a problem. In other cases, these topics address functionality available only with the techniques covered during this lesson. In this lesson, you find out:
How to work with stored procedures and temporary tables
How to utilize cursors in the stored procedures you build
How stored procedures interact with the security of your database ...