good tsql reference book
-
Does anyone know a good tsql reference book?
I've been using BOL and am wondering if there is anything else out there people would recommend.
Thanks
-
Ken Henderson writes a good book called "Guru's Guide to Transact-SQL". There is also the book by Itzik Ben-Gan and Tom Moreau titled "Advanced Transact-SQL for SQL Server 2000". Both are great books in my opinion.
I started with the Ken Henderson book and that would be my recommendation for anyone asking.
Just one opinion.
David
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
-
One that is often referenced and usually on my bookshelf (it keeps getting borrowed) is Profession SQL Server (7.0/2000) Programming by Rob Viera.
K. Brian Kelley
http://www.sqlservercentral.com/columnists/bkelley/
K. Brian Kelley
@kbriankelley -
I purchased both books mentioned and found both useful depending on what you want to do.
Rob Vieira's "SQL Server 2000 Programming" gives you a great overview. He has a humorous approach to the whole subject, if you like his writing style.
ISBN# 1-861004-48-6
Wrox Press
Ken Henderson's "The Guru's Guide to Transact-SQL" is also a great book and gives you more in-depth information on the subject.
ISBN# 0-201-61576-2
Addison-Wesley
(He's also produced a second book "The Guru's Guide to SQL Server Stored Procedures, XML and HTML")
If you search for the books at Amazon, you'll notice that they both get pretty good recommendations. (I think they are both 4 to 5 star books)
__________________________________
Searching the KB articles is like
picking your nose. You never know
what you'll find.
__________________________________
Searching the KB articles is like
picking your nose. You never know
what you'll find. -
Although not TSQL specific, Joe Celko's SQL For Smarties has always been one of my favorites.
-Mike
Michael Levy
Michael Levy
ma_levy@hotmail.com -
That's a good book.
Another one that's got me reading lately is the Transact-SQL Cookbook by Spetic and Gennick. It presents the material in a little different format than the other T-SQL books out there. For instance, the chapter on heirarchies uses a Problem, Solution, Discussion format to work through some examples.
If you have purchased a subscription with Safari (http://safari.informit.com or http://safari.oreilly.com) this book is available as a 1 point towards the subscription.
K. Brian Kelley
http://www.sqlservercentral.com/columnists/bkelley/
K. Brian Kelley
@kbriankelley
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply