SQL Server 2000 Stored Procedure Handbook - Softcover

Tony Bain; Robin Dewson; Chuck Hawkins; Louis Davidson

 
9781861008251: SQL Server 2000 Stored Procedure Handbook

Synopsis

If you want to write better stored procedures, this is the book for you.

This book will tackle 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.

This book is for the SQL Server 2000 developer, who wants a book that starts where books like Rob Viera's Professional SQL Server 2000 Programming finish.

Topics covered include:

Typical uses and misuses of stored procedures
Debugging and optimizing stored procedures
System stored procedures and extended stored procedures
Cursors, transactions and concurrency
Working with triggers
User defined functions
Stored procedures and security

"synopsis" may belong to another edition of this title.

From the Publisher

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.

"About this title" may belong to another edition of this title.