SQL Server 2000 Stored Procedure Handbook - Softcover

Davidson, Louis; Bain, Tony; Dewson, Robin; Hawkins, Chuck

 
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.