SQL Server 2000 Stored Procedures Handbook

Description

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. Front Matter....Pages N2-viii Introduction....Pages 1-3 Stored Procedures Overview....Pages 4-32 Optimizing and Debugging....Pages 34-62 Concurrency, Cursors, and Transactions....Pages 64-109 Common Practices with Stored Procedures....Pages 110-133 System Stored Procedures....Pages 134-176 User Defined Functions....Pages 178-195 Triggers....Pages 196-217 Security....Pages 218-245 Back Matter....Pages 246-270