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 guide to a key area of database development. This book tackles 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. Put simply: if you want to write better stored procedures, then this is the book for you. Handbook shows how to write faster and more robust stored procedures and functions; learn effective, real-world solutions to common problems faces by database developers, designers, and administrators; and master topics such as optimizing and debugging procedures, and handling transactions and concurrency. For intermediate to advanced level users. Softcover.

+ Author: Tony Bain
+ Publisher: Apress
+ ISBN: 1590592875

download