SQL Server 2000 Stored Procedures Handbook

This handbook shows how to write faster and more robust stored procedures and functions, learn effective, real-world solutions to problems faced by database developers, designers, and administrators, and master topics such as optimizing and debugging.

As well as being used for fundamental database administration, stored procedures are the cornerstone of any kind of database solution. Mastery of stored procedures is imperative to access and modify your data in the most effective way, as well as to keep your database secure and performing well. This book is a must on your road to that mastery.

This book is dedicated to stored procedures and the surrounding aspects of SQL Server 2000 that affect their operation. In here you will find many useful tips, facts, and techniques that will help you to get the most from your stored procedures. Whether you are accessing data from a client application, performing database administration with system stored procedures, or even using extended stored procedures to work with other parts of the operating system, you will hopefully find information that will make you review your own dealings with stored procedures, and ensure the continuous improvement of your database solutions.

SQL Server 2000 administrators and designers will benefit from this book, as will experienced SQL Server 2000 developers who are already familiar with the basic concepts of stored procedures.