> The title is "The Guru's Guide to Stored Procedures, XML, and HTML."
> I'm wondering if anyone has read this book and what they think of it.
> I have his first book and am tempted to order the new one based on
> that alone. I'm wanting a book that shows how to build xprocs from
> start to finish. I can code in C and C++, but I've never built an
> xproc. I want to know how to build them, debug them, optimize them,
I just got this from Amazon, and it's a wonderful book. Even better
than the first one (if you can believe that). What I like about this
one is that it balances theory and pratical concerns so well. On the
one hand, the book has over 700 code samples on everything from xprocs
to XML to UDFs to C# code. On the other, it's not just a solutions
cookbook. Henderson delves into the "why" as much as he does the
"how." That's really rare for a technical book in my experience.
To your question, there's great xproc coverage in this book. I worked
through the step-by-step tutorial on building one called "xp_exec" the
other day. It lets you execute any code you want from a UDF including
all the stuff SQL Server normally forbids. It was a piece of cake.
The text is so lucid and well thought out that you learn without
really realizing it.
And I can't say enough about the XML coverage. The book has several
chapters on the XML features in SQL Server 2000, including an intro
chapter on XML itself for those who don't yet know the language. I've
gone from barely knowing how to spell XML to using SQL Server's
advanced XML features in a matter of days. I found the XML coverage
worth the price of the book alone and don't know how I ever got along
So, I'd say if you liked the first Guru's Guide book, I'll bet you'll
like this one, too, especially if you're wanting to learn to build
Hope that helps,