Writing Stored Procedures for Microsoft SQL Server

Complex Stored Procedure Creation

In Chapter 5, "Creating and Altering Stored Procedures," I discussed the creation of simple stored procedures that return very simple data by using the SELECT statement. These procedures were pretty simple, but the framework is now there to create more complex stored procedures that can accept parameters, pass values into variables, and contain error-trapping routines that return errors to the user. These stored procedures can be extremely complicated and they enable developers to create powerful applications that reside in the database layer.