Writing Stored Procedures for Microsoft SQL Server

Creating Stored Procedures

The actual creation of a stored procedure is quite easy. The work that happens before you actually create the procedure is difficult. Before you create the procedure, you must first create and debug the query that is executed inside the procedure. The first part of this might be to create pseudocode that outlines the functionality contained in the stored procedure you are creating. This pseudocode will act as a roadmap during creation of the query.

The query can be as complex or as simple as you need. In this chapter, the stored procedures you will create are simple SELECT statements. Users who are experienced with the SELECT statement, logical operators, comparison operators, and Boolean expressions will want to ...