Writing Stored Procedures for Microsoft SQL Server

Chapter 5. Creating and Altering Stored Procedures

IN THIS CHAPTER

• Creating stored procedures

• SELECT statements

• Using Cursors

• CREATE PROCEDURE

• The changing of the code—altering stored procedures

• Alteration considerations

Now that you have learned how SQL Server stored procedures work, it is time to start creating stored procedures. Almost any query you write can be turned into a stored procedure. This approach enables you to run any query by executing a single command. This helps to insulate the application and the application developers by hiding the complexities of the SQL queries. Creating the actual stored procedure is relatively easy, after the query has been written and debugged. In this chapter, you will look at the basics of ...