O'Reilly logo

All-In-One MCITP SQL Server 2005 Database Developer by Darril Gibson

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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. ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required