Writing Stored Procedures for Microsoft SQL Server

Conclusion

In this chapter, you saw how to use stored procedures to add data to tables within your database. First, you saw an overview of the INSERT command and how to use it with the SELECT and EXECUTE statements. After that, you saw how to use cursors to help you eliminate blocking situations. Last, you saw how to create a stored procedure that will assist you in the creation of INSERT stored procedures.