CHAPTER 9Stored Procedures

In this chapter, you will learn about:

• Stored procedure uses and benefits

• Stored procedure types

• Transactions

• Error handling including TRY CATCH

• Creating user-defined stored procedures

• Stored procedure security

• CLR-integrated stored procedures

Success is more a function of consistent common sense than it is of genius.

—An Wang

Stored procedures are powerful. We have the capability of encapsulating complex business logic, enhancing security, preventing SQL injection attacks, reducing network traffic, and much more through the use of stored procedures. And once created, all you have to do is grant Execute permission to allow users to run them—no matter how complex the logic or how many tables are accessed. ...

Get MCITP SQL Server 2005 Database Developer All-in-One Exam Guide (Exams 70-431, 70-441 & 70-442) now with O’Reilly online learning.

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