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 the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.