I'm looking for recommendations of good books to use learning Transact-SQL for MS SQL Server 2000. I'd go for ORA's Programming Transact-SQL, but it looks like it hasn't been updated for SQL ...

If you want to really enjoy reading a technical book or learning a new computer skill set, you just have to check out O’Reilly’s “Head First” series. These books fully earn their “brain ...

So far I've read through the Learning SQL book and also the Learning PL/SQL book from O'Reilly, and they are very informative and helpful, but only to a certain extent.