Great coverage of Transact-SQL,
This review is from: The Guru's Guide to Transact-SQL (Paperback)
Oops... the comments below were for another book by Ken Henderson: The Guru's Guide to SQL Server Stored Procedures, XML and HTML. However I also have the Guru's Guide to Transact-SQL and I use it daily to get around SQL. Another excellent book!
Finally a book that gives you, in the same chapter, a way to do arrays in SQL, and an excellent example of how to use extended stored procedures, and system functions.
When I search for a good book, I look at a lot of books on the shelves, and often notice that many books just duplicate information readily available at "Books on line" or MSDN. This one doesn't do that. It explores a lot of topics that, although they do not appear immediatly useful, sooner or later will save you a lot of time.
And that's what I look for when I buy a book! This extra wealth of information that makes a difference when you have to program something of higher complexity that usual.