This book was written so that you can learn how to create stored procedures. I'm
sure that you have created a few stored procedures already. The first stored
procedures I created were simple queries that I encapsulated so that I didn't have to
reload or retype them every time I wanted to run them. After a while, I learned how
useful stored procedures can be. Hopefully, this book will assist you in moving down
the path of creating useful and powerful stored procedures. You'll learn some
techniques that will help you create stored procedures that will provide all the results
your users expect while remaining friendly to the system.
You must fulfill some prerequisites before you can effectively use the information
presented in this book. First, you must have a solid understanding of the Transact-
SQL (T-SQL) language. This book provides some review of the commands that make
up T-SQL, but the review is not extremely in-depth and might cause you some
frustration if you haven't previously seen how T-SQL works.