Join Amazon Prime and ship Two-Day for free and Overnight for $3.99. Already a member? Sign in.


Sign in to turn on 1-Click ordering.
More Buying Choices

Have one to sell? Sell yours here
The Guru's Guide to SQL Server Stored Procedures, XML, and HTML (With CD-ROM)
The Guru's Guide to SQL Server Stored Procedures, XML, and HTML (With CD-ROM) (Paperback)
by Ken Henderson (Author) "Working from the assumption that the human brain learns by associating new data with what it already knows, we'll spend this chapter building a base..." (more)
Key Phrases: ecid status loginame, idx value, orphaned transactions, Customers Customerld, Query Analyzer, Ken Henderson (more...)
(82 customer reviews)                                                                                                                                                 

List Price: $64.99
Price: $38.99 & this item ships for FREE with Super Saver Shipping. Details
You Save: $26.00 (40%)

Availability: In Stock. Ships from and sold by Gift-wrap available.

Want it delivered Tuesday, August 14? Choose One-Day Shipping at checkout. See details

Keep connected to what's happening in the world of books by signing up for Books Delivers, our monthly subscription e-mail newsletters. Discover new releases in your favorite categories, popular pre-orders and bestsellers, exclusive author interviews and podcasts, special sales, and more.

Product Promotions
Get free two-day shipping on this item when you spend $200.00 or more on Qualifying Textbooks offered by Prime members will also receive a $20 promotional certificate to be used for a future purchase. Enter code TBFALLO7 at checkout. Here's how (restrictions apply)

Better Together
Buy this book with The Guru's Guide to Transact-SQL by Ken Henderson today!
The Guru's Guide to SQL Server Stored Procedures, XML, and HTML (With CD-ROM) The Guru's Guide to Transact-SQL
Buy Together Today: $78.25

Editorial Reviews
Book Description

SQL Server developers worldwide raved about Ken Henderson's The Guru's Guide to Transact-SQL: its exceptionally clear, conversational explanations, and its powerfully useful projects and code examples. This book helps SQL Server developers take the next step -- building more powerful, robust applications than ever before. Henderson identifies several key areas of SQL Server development that offer the greatest power -- and then covers each of them in exceptional detail. The book includes especially thorough coverage of Transact-SQL stored procedure programming, including features such as extended procedures, database design, and XML that are often disregarded in competitive books. Henderson introduces a method he has developed to add arrays to T-SQL, something previously thought impossible. He offers an ideal balance of theory and code, gradually building on basic techniques to create increasingly sophisticated solutions, and teaching the philosophy of Transact-SQL programming alongside syntax and technique. An accompanying CD-ROM includes extensive source code, including valuable proprietary code that makes T-SQL queries run faster. For every SQL Server developer.

Book Info
Teaches that stored procedure development does not occur in a vacuum--it involves a wide variety of skills, subjects, and technologies--and helps the reader become a better software engineer, not just a stored procedure expert. The most complete coverage of SQL Server stored procedure programming available in one source. Softcover. CD-ROM included.

See all Editorial Reviews

Product Details

Inside This Book (learn more)
First Sentence:
Working from the assumption that the human brain learns by associating new data with what it already knows, we'll spend this chapter building a base framework onto which we can assemble the knowledge conveyed by the remainder of the book. Read the first page
Key Phrases - Statistically Improbable Phrases (SIPs): (learn more)
ecid status loginame, idx value, orphaned transactions, reconfigure with override, undocumented routines, srv senddone, fillfactor setting, source code management system, scan fragmentation, partitioned view, int identity, table aliases, indexed views, region nvarchar, server error log, undocumented functions, parameterized view, clustered index, extended procedure, procedure cache, partitioning column, mapping schema, query plan, int declare, trace flags
Key Phrases - Capitalized Phrases (CAPs): (learn more)
Customers Customerld, Query Analyzer, Ken Henderson, Order Details, Orders Orderld, Ana Trujillo Emparedados, Books Online, Alfreds Futterkiste, Antonio Moreno, Visual Basic, Enterprise Manager, Index Scan, Harry Connick, Johnny Hartman, Visual Studio, Microsoft Press, Sonny Cried, After the Gold Rush, Berkeley Square, Easy Living, Nightingale Sang, Tenant Number, Wellington Importadora, Wilman Kala, Wolski Zajazd
Books on Related Topics | Concordance | Text Stats
Browse Sample Pages:
Front Cover | Copyright | Table of Contents | Excerpt | Index | Back Cover | Surprise Me!
Search Inside This Book:

What Do Customers Ultimately Buy After Viewing Items Like This?
55% buy the item featured on this page:
The Guru's Guide to SQL Server Stored Procedures, XML, and HTML (With CD-ROM) by Ken Henderson $38.99
25% buy
The Guru's Guide to Transact-SQL by Ken Henderson $39.26
10% buy
Microsoft SQL Server 2005 Stored Procedure Programming in T-SQL & .NET by Dejan Sunderic $37.79
5% buy
The Guru's Guide to SQL Server Boxed Set by Ken Henderson $83.99
5% buy
Beginning Transact-SQL With SQL Server 2000 and 2005 by Paul Turley $23.99

Tags customers associate with this product (What's this?)
Click on a tag to find related items, discussions, and people.
Check the boxes next to these popular tags or enter your own tags in the field below

Your tags: Add your first tag
Help others find this product - tag it for Amazon search
No one has tagged this product for Amazon search yet. Why not be the first to suggest a search for which it should appear?
Search Products Tagged with

Are you the publisher or author? Learn how Amazon can help you make this book an eBook.
If you are a publisher or author and hold the digital rights to a book, you can make it available as an eBook on Learn more

Rate this item to improve your recommendations

I Own It Not Rated Your Rating
Don't Like It < > I Love It!
Save Your






Customer Reviews
82 Reviews
5 star: 81%  (67)
4 star: 7%  (6)
3 star: 3%  (3)
2 star: 4%  (4)
1 star: 2%  (2)
Average Customer Review
Share your thoughts with other customers:
Write an online review
Most Helpful Customer Reviews

108 of 129 people found the following review helpful:
Another great Ken Henderson SQL book, March 7, 2002
By John Lennox (Hampton Falls, NH USA) - See all my reviews
I bought the first Guru's Guide -- The Guru's Guide to Transact SQL -- as a way to fine-tune my SQL skills when I began a new job as a SQL Server Admin / Developer. Nearly two years later, I still find myself reaching for that book for almost every unique SQL problem that I encounter, and I am rarely disappointed. When I saw that Henderson had written another SQL book, I expected another winner. I was not disappointed.

The coverage of stored procedures, user-defined functions, and XML was first-rate. And the relatively short chapter on .NET was loaded with reasons why every SQL Server developer should be embracing this new techology.

The Essays on Software Engineering were extremely well-written. The intermingling of personal experiences and reflection with the technical details of the topics was done just right. It added a certain amount of relevance to the section that made it feel less like a theoretical lecture and more like the sharing of information by a well-respected colleague. One who has obviously experienced these things and knows what he is talking about. On the surface, these essays may seem a bit out of place in a book about Stored Procedures and XML but, in fact, they fit very well with the overall theme of the book: SQL and Stored Procedure development is "real" software engineering and needs to be treated as such if you are going to be good at it.

114 of 134 people found the following review helpful:
Henderson takes it to a new level, January 12, 2002
By Donald Farris (Jersey City, NJ USA) - See all my reviews
I never thought I'd say this but this book is even better than the first Gurus Guide book! Henderson cuts loose and just writes. It feels like you've got the guru sitting right next to as you read.

As with his first book, Henderson runs a tight ship with this one. There's no fluff or other filler material. Instead, you just get the goods, and you get them by the boatload.

My fav things about this one are:

* Extended Proc coverage. I've always wondered how to build these. The coverage in this book is absolutely excellent. It could be a book unto itself.

* XML coverage. I've never seen a better cut-to-the-chase introduction to XML and the XML features in SQL Server. It's a wonderful, hands-on tutorial written by a master.

* Emphasis on treating transact-sql as a real language. Henderson stresses this over and over and he's right. This book is every bit as good as the high-end programming books that feature languages like C++ and Java.

* Essays on software engineering. These are some of the best technical writing I've ever read.

I don't think you could spend your money on a better SQL Server book.


11 of 11 people found the following review helpful:
Excellent on some topics, unfocused overall, November 8, 2004
By Jack D. Herrington "engineer and author" (Silicon Valley, CA) - See all my reviews
There is a lot to like in this book. The chapter on database design is fantastic. The chapter on views is excellent as well. But overall the book veering off topic now and again, which adds to it's girth (760 pages.)

The book starts with a very solid introduction to stored procedures. As I say, the database design portion of the first part is probably worth the price of admission on it's own.

Part two is titled objects, which is a little deceptive since the chapter mainly covers functions, triggers, stored procedures and other structural elements.

Part three is where the book gets into XML and HTML. There is some introductory material on XML and XSL which is too brief to be a complete introduction for someone. That material is better presented in other books. But the material on XML queries direct to the SQL server is unique and valuable.

Part four on advanced topics has some good chapters. In particular the section on query optimization is well done and serves as a good introduction to the topic. But this part is where the book veers off course and into topics like testing, refactoring, XP, and an introduction to the .NET framework and C#. It's all interesting, but it's covered better in other books and the book overall could be shorter and more focused were it not for these sections.

Another downside is that Illustrations are a little underused. But the downsides aside, this is a great book, specifically for the first two parts including the excellent section on database design.

Share your thoughts with other customers: Write an online review
Most Recent Customer Reviews

Not as good as his first effort
I bought Ken Henderson's Guru's Guide to T-SQL a few years back and was extremely impressed with it. Read more
Published 4 months ago by Paul O'Connor

A lot of the information relates to older release of SQL server
This book would be fantastic if I would still run an older release of the SQL server ... and the stored procedures part is still very relevant. Read more
Published 12 months ago by Ivan Pepelnjak

Best Book for Hoardcore SQL Server
This book is for experienced SQL developers. No fancy stuff. I found it very useful, since you will find lot of material you won't find anywhere else. Read more
Published 16 months ago by Paul Sarkisian

This is the book for SQL Developers/DBAs
I have about $2000 worth of the book on, cfml, Microsoft SQL server, Oracle DB book, and other tech related books. Read more
Published on March 25, 2005 by Elijah Li

This book is essential for those building solutions with Sql Svr. It is really a developer's take on how to create applications based on the world's best database. Read more
Published on March 18, 2005 by Charles McNutt

Not useful for SQLXML
The XML coverage in this book is not useful for anyone interested in doing full blown XML development. Read more
Published on May 29, 2004 by James Goodman

Best book on SQLXML
What is really great about this book is how it tackles SQLXML wholistically--it does not assume that you already know XML and starts from ground-zero. Read more
Published on May 29, 2004 by Andrew M.

For professional developers
It's funny that no one thought of this before but the book has a message that is unique and new...writing code for Sql Server has to be approached like writing code for any other... Read more
Published on May 28, 2004 by Drew M.

best book on VSS i've seen
I never got the hang of Visual sourcesafe until this book. Thank you for writing a book on this obscure topic. Read more
Published on May 25, 2004

Essential if you want to use XML with Sql Server
I have over ten years of experience in the database profession. I bought all three of Henderson's books a few months ago and have been studying them ever since. Read more
Published on May 22, 2004 by Sally K. Brace

Search Customer Reviews
Only search this product's reviews


Customer Discussions Beta (What's this?)
New! Receive e-mail when new posts are made. Click the "Track it!" button on any discussion page.
This product's forum (0 discussions)
Discussion Replies Latest Post
No discussions yet

Ask questions, Share opinions, Gain insight
Start a new discussion
First post:
Receive e-mail when new posts are made
Prompts for sign-in


Product Information from the Amapedia Community Beta (What's this?)

So You'd Like to...

Have a shopping question?
Try askville. It's free!

Big Savings in Books
Find great titles at fantastic prices in our Bargain Books Store.

Buy Three Books, Get a Fourth Free
Order any four eligible books under $10 and get the lowest-price book free in our 4-for-3 Books Store. See more details.

Save up to 50% in Grocery
Save $25--plus get FREE Super Saver Shipping--when you spend $49 or more on any combination of Conagra brands, including Orville Redenbacher, Healthy Choice, Chef Boyardee, Slim Jim, Libby, Jiffy Pop, and more.

  More Special Offers in Grocery

Spectacular Textbook Savings
Save up to 30% on over 100,000 new textbooks, and up to 90% off the list price of millions of used listings, in our Textbook Store.


Where's My Stuff?
Shipping & Returns
Need Help?
Conditions of Use | Privacy Notice © 1996-2007,, Inc. or its affiliates