SQL Server 2000 Stored Procedures Handbook (Expert's Voice)

Bain, Tony/ Davidson, Louis/ Dewson, Robin

Apress（2003/09発売）

• 製本 Paperback:紙装版/ペーパーバック版／ページ数 266 p.
• 商品コード 9781590592878
• DDC分類 005.758

Full 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.

Contents

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