Writing Stored Procedures for Microsoft SQL Server

Chapter 8. Creating Stored Procedures that Modify Data

IN THIS CHAPTER

• Verifying the data to be modified

• Creating procedures to delete data

• Automating code creation

In the previous two chapters, you've seen the ins and outs of creating stored procedures that query and add data to your database tables. In this chapter, you see how to create stored procedures that modify data. You see some pitfalls of creating stored procedures, such as verifying the data that is to be modified and maintaining relationships between tables when you make changes to table keys.

The following subjects are covered in this chapter:

• Verifying data to be modified

• Creating procedures to delete data

• Automating the creation of the code