Good SQL Server book recommendation.

[NormDroid]

I'm after a book on programming stored procedures in SQL Server, recommendations anybody? Thanks

I am that is

[Jeffry van de Vuurst]

The Guru's Guide to SQL Server Stored Procedures, XML, and HTML[^] By Ken Henderson That's the one I have, and I like it. Regards, Jeffry

[NormDroid]

Jeffry What's the content on the Stored Procedure like? Thanks

I am that is

[Jeffry van de Vuurst]

Well, maybe I was a bit misleading. The book actually covers a lot more besides only stored procedures. So there are only a few chapters devoted to stored procedures alone. It covers extended stored procedures, administrative stored procedures in sql server, and the basics about writing stored procedures. So if you only want to focus on stored procedures, you might want to try another book.

[Jeremy Falcon]

MSDN and SQL Books Online. :) Jeremy Falcon

[Member 96]

No question: "The guru's guide to SQL server stored procedures XML and HTML" by Ken Henderson followed by any other book he has written about SQL server There are even a few used ones available on Amazon: http://www.amazon.com/exec/obidos/tg/detail/-/0201700468/qid=1078512685/sr=1-3/ref=sr_1_3/104-1137109-5983163?v=glance&s=books[^]

---

I support two teams: The Canucks and whoever is playing the Leafs.

[NormDroid]

Thanks John, I'm actually gonning to buy: "The Guru's Guide to Transact-SQL", that is the language used to write stored procedures - right?

[NormDroid]

Thanks for the tip, should I dig out my early '92 editions of MSDN as well ;P

[Member 96]

Ahh! Sorry, I thought you specifically were looking for a book on stored procedures. Yes, stored procedures are written in Transact SQL. If you don't already know transact sql I can definitely recommend that book because I have it as well. In fact you should really buy both if your ultimate goal is to build a lot of stored procedures as the s.p. book contains a lot of useful info specific to stored procedures and programming with them in general. You can probably pick up both used from amazon for what I paid for one of them at a local book store.

---

There is much to be said in favor of modern journalism. By giving us the opinions of the uneducated, it keeps us in touch with the ignorance of the community. - Oscar Wilde

[NormDroid]

Cheers for the info.