O'Reilly logo

Writing Stored Procedures for Microsoft SQL Server by Matthew Shepker

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required