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 ...

Get Writing Stored Procedures for Microsoft SQL Server now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.