Lesson 16. Stored Procedure Special Topics

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:

Image How to work with stored procedures and temporary tables

Image How to utilize cursors in the stored procedures you build

How stored procedures interact with the security of your database ...

Get Sams Teach Yourself T-SQL in One Hour a Day now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.