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