Writing Stored Procedures for Microsoft SQL Server

Uses for Stored Procedures

You might already have a good idea of what can be done with stored procedures. However, probably much more can be done with stored procedures than you've ever thought of. Truthfully, probably quite a bit more can be done than I have ever thought of. The great thing about stored procedures is that, as a developer, you can create stored procedures that do whatever you need them to do. The following is a list of some of what you can do with stored procedures and reasons for using them. Most of these items are covered in this book; over time, you will discover others.

• Encapsulation of Queries— One of the first uses I discovered for stored procedures was to encapsulate queries so that I didn't have to worry about where they ...