Writing Stored Procedures for Microsoft SQL Server

Chapter 7. Creating Stored Procedures that Insert Data

IN THIS CHAPTER

• Inserting data with the INSERT statement

• Inserting data into views

• Inserting data based on a SELECT statement

• Inserting data with an EXECUTE statement

• Minimizing blocking conditions

• Automating the creation of the code

So far, the stored procedures we've looked at and worked with have dealt only with getting data out of the database using SELECT statements. There is much more to stored procedures than that. Stored procedures can also be used to INSERT data into your tables. When adding data to your tables using stored procedures, you need to consider several things. We cover all these considerations in this chapter.

In this chapter, we cover the following:

• Inserting ...