SQL Server 2000 Stored Procedure Programming

By Tom Woodhead and Dejan Sunderic

Book Overview

This is a guide to building and using stored procedures in SQL server applications. Stored procedures are used for a variety of complex data gathering tasks, to optimize performance. This description may be from another edition of this product.

• Format: Paperback
• Language: English
• ISBN: 0072125667
• ISBN13: 9780072125665
• Release Date: October 2000
• Publisher: McGraw-Hill/Osborne Media
• Length: 752 Pages
• Weight: 3.20 lbs.
• Dimensions: 1.6" x 7.4" x 9.2"

Customer Reviews

An Excellent Learning Tool

As a software developer with many years of hands-on experience, I continually need to upgrade my skills as efficently as possible. What I value most in a book is how clearly it explains the concept and practice of a particular subject, thus allowing me to quickly get my hands on it to discover its nuances and idiosyncrasies.I found this book to be very logically organized, thorough in its coverage of most subjects without...

A gem of a book

Sunderic and Woodhead have written a gem of a book that can earn on place on almost every SQL Server 2000 developer's bookshelf, if not desk. Whether you are an experienced developer new to SQL Server, or an old hand upgrading to 2000, SQL Server 2000 Stored Procedure Programming will introduce you to the features you need to know about. The writing style is clear and easy to read, and the explanations clear, concise and...

Awesome

As a consultant, I occasionally meet and work with talented individuals who have the natural ability to unfold complex problems into manageable sections and explain them in simple and understandable terms. The authors of this book successfully achieve this status. This book caters to all users, from beginners to experts. It includes lots of tips, tricks and pitfall warning notes for the casual user right through to intense...

Finally

I have been looking for a book like this for two years. This is the first book I've found that goes beyond the usual trivial stored procedure examples with one or two select and/or insert statements. It has everything I need - loops, conditional execution, error handling, debugging, dynamic queries. And the sample database has some great, real-world examples of very complex stored procedures.

Great book

Everybody's talking about XML these days and now even SQL Server supports it. This book has a great introduction to XML for DBAs-everything you ever wanted to know about tags, elements, attributes, DTDs, schemas and XPath, but were afraid to ask. After introducing XML, the authors go on to describe how Microsoft has implemented it in SQL Server, and how you can use it to build simple Web applications for querying databases...