Hi,

I feel SQL Bible has a lot of info on T-SQL. There are chapters dedicated to SELECT, UPDATE, INSERT, DELETE statements, JOINS.

And then there are chapters on Triggers,SP,Views, I mean...