SQL Server 2000 Stored Procedure Handbook

If you want to write better stored procedures, this is the book for you. 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