SQL Server 2000 Stored Procedures Handbook - Reprint

Description

Stored procedures are compiled T-SQL statements that reside on the database, and are the cornerstone of successful data manipulation; data-handling operations of any 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 how to solve these problems, avoid the common pitfalls and work around them, to produce faster, more robust stored procedures. Put simply: if you want to write better stored procedures, then this is the book for you.

CONTENTS

Chapter 1--Stored Procedures Overview
Chapter 2--Optimizing and Debugging
Chapter 3--Concurrency, Cursors and Transactions
Chapter 4--Common Practices with Stored Procedures
Chapter 5--System Stored Procedures
Chapter 6--User Defined Functions
Chapter 7--Triggers
Chapter 8--Security