Posted by Erland Sommarskog on 07/17/06 20:39

blueghost73@yahoo.com (blueghost73@yahoo.com) writes:
> I do software support for software that works with both Oracle and SQL
> Server, so I mostly just write queries to look at the data related to
> the software. When I first started, I bought a couple of books to learn
> the basics, intentionally going with generic books that would help with
> both types of databases. I've got the basics down, and now I'm looking
> for a really detailed reference book that goes really indepth into
> querying for SQL Server specifically. Currently, we only work with the
> 2000 version, but we'll be going to 2005 soon, so I think I'd rather go
> with a book on 2005, although if you know one that covers the
> differences between them, that would be great. Any recommendations?

The ultimate book on writing queries on SQL 2005 simply must be "Inside
T-SQL Querying" by Itzik Ben-Gan on Microsoft Press. If there is a problem
he can't write a query for, then there is simple is no query to write - or
the query is not worth writing. I'm just about to read the book myself,
so I cannot say how much he compares with SQL 2000.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[Back to original message]