a good book on MSSQL/SQL SERVER

See more:

SQL-Server

hi can any one tell me a good book on sql sever because i college i was taught oracle 9i and that was 2 years back and as know there are some synatx/keyword differnce so would like to get first hand knowledge of mssql/sql server .

for eg consider following trigger statement which is in oracle

create trigger <triggername> 
before delete on <tb1>
for each row
begin
insert into <newtablename> values(:old.column1 , :old.column2...)
end </newtablename></tb1></triggername>

now this code would give error in sql server as it wont recognize old keyword also syntax around colon

its equivalent for mssql/sql sever would be(which i got from net/help from friends)

create trigger <triggername>
on <tb1>
for insert
as 
declare 
@variable1 varchar(10)
select @variable=var form tb1
begin 
insert into <newtable> values(@variable)
end  </newtable></tb1></triggername>

so friends as one can see difference in syntax as well as keywords so please suggest me a good book on mssq/sql server
thanks
anoop