Writing Stored Procedures for Microsoft SQL Server

Introduction

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.

Prerequisites

You must fulfill some prerequisites before you can effectively use the information presented ...