Stored procedures are compiled T-SQL statements that reside on the database. They are the cornerstones of successful data manipulation, and data-handling operations of every complexity make use of them. This book is an in-depth guide to a key area of database development.
This book tackles real-world problems faced by developers when working with stored procedures, showing you how to solve these problems, avoid the common pitfalls, and produce faster, more robust stored procedures. Put simply: if you want to write better stored procedures, then this is the book for you.
| Introduction | 1 | |
| Ch. 1 | Stored Procedures Overview | 5 |
| Ch. 2 | Optimizing and Debugging | 35 |
| Ch. 3 | Concurrency, Cursors, and Transactions | 65 |
| Ch. 4 | Common Practices with Stored Procedures | 111 |
| Ch. 5 | System Stored Procedures | 135 |
| Ch. 6 | User Defined Functions | 179 |
| Ch. 7 | Triggers | 197 |
| Ch. 8 | Security | 219 |
| App. A | Support, Errata, and forums.apress.com | 247 |
| Index | 251 |
Overview
Stored procedures are compiled T-SQL statements that reside on the database. They are the cornerstones of successful data manipulation, and data-handling operations of every complexity make use of them. This book is an in-depth guide to a key area of database development.
This book tackles real-world problems faced by developers when working with stored procedures, showing you how to solve these problems, avoid the common pitfalls, and produce faster, more robust stored ...