SQL Server 2000 Stored Procedures Handbook [Paperback]

* Shows you how to write more effective stored procedures and functions

* Concise, detailed advice from SQL Server experts

* Tackles issues barely covered in existing books, such as optimizing and debugging, concurrency and transactions.

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.

A table of contents is not available for this title.Robin Dewson has been hooked on programming ever since he bought his first computer, a Sinclair ZX80, in 1980. He has been working with SQL Server since version 6.5 and Visual Basic since version 5. Robin is a consultant mainly in the city of London, where he has been for nearly eight years. He also has been developing a rugby-related website as well as maintaining his own site at Fat-Belly.com.

Shows you how to write more effective stored procedures and functions

Gives concise, detailed advice from SQL Server experts

Tackles issues barely covered in other books, such as optimizing and debugging, concurrency and transactions

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 guidelĂ`