SQL Server 2000 Stored Procedure Handbook

This book will tackle 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.

This book is for the SQL Server 2000 developer, who wants a book that starts where books like Rob Viera's Professional SQL Server 2000 Programming finish.

Topics covered include:

Typical uses and misuses of stored procedures
Debugging and optimizing stored procedures
System stored procedures and extended stored procedures
Cursors, transactions and concurrency
Working with triggers
User defined functions
Stored procedures and security