Table of Contents

sql server 2000 stored procedures handbook
SQL Server 2000 Stored Procedures Handbook
byTony Bain, Louis Davidson, Robin DewsonandChuck Hawkins ISBN:1590592875
Apress 2003 (288 pages)

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.

Table of Contents
SQL Server 2000 Stored Procedures Handbook
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
Appendix A - Support, Errata, and
List of Figures
List of Examples

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.

About the Authors

Tony Bain is the founder of Tony Bain & Associates. He has worked with SQL Server for the last 6 years, and he is passionate about all database technologies, especially when they relate to enterprise availability and scalability. Tony currently holds the Microsoft Certified System Engineer, Microsoft Certified Solution Developer, and Microsoft Certified Database Administrator certifications.

Louis Davidson has been in the IT industry for 10 years as a corporate database developer and architect. He is currently a database administrator for Compass Technology Management, supporting the Christian Broadcasting Network and NorthStar Studios in Nashville, Tennessee.

Robin Dewson has been hooked on programming ever since he bought his first computer in 1980, a Sinclair ZX80. His first main application of his own was a Visual FoxPro application that could be used to run a Fantasy League system. It was at this point he met up with a great help in his PC development life, Jon Silver at Step One Technologies, where in return for training, he helped Jon with some other Visual FoxPro applications. From there, realizing that the marketplace for Visual FoxPro was limited, he decided to learn Visual Basic and SQL Server.

Chuck Hawkins is a senior consultant and database administrator in Virginia Beach, Virginia. He works for Compass Technology Management, where he manages the daily ups and downs of multiple servers for several large ministries. He has extensive experience in T-SQL programming, replication, performance tuning, developer management, and routine server management. Chuck has spoken at the Professional Association for SQL Server conferences in the United States and the UK. He has contributed columns to several magazines and was a contributing author to Professional SQL Server 2000 Database Design.