Chapter 4: Common Practices with Stored Procedures

Overview

In the previous chapters, we discussed the benefits, disadvantages, and the syntax of stored procedures. In this chapter, we will focus on the purposes of stored procedures within our applications. Here's an outline of what we intend to discuss:

• Typical purposes of stored procedures

• Points to avoid while using stored procedures

Note

This chapter assumes that you are familiar with the stored procedure creation syntax and T-SQL in general. If you want clarification regarding the syntax, please feel free to refer to the earlier chapters.