Writing Stored Procedures for Microsoft SQL Server

Conclusion

In this chapter, you have seen the basics of creating stored procedures. It is imperative that you realize how important it is to plan out exactly how the stored procedure will work before you actually create the procedure. This will keep you from having to re-create the procedure over and over again. First, you saw an overview of the SELECT statement. Then you saw how you can use cursors to return data to the users. Then came the important stuff: the actual creation of some procedures. These procedures were relatively simple, but don't worry, there are some more complicated ones in the future. The last thing you saw in this chapter was a discussion of how to modify stored procedures that are already created.