i am anoop and new here and hope it would fun and learning experince on dbforums. also as this is my first post i would require and help regarding good book on mssql .i have some knowledge of oracle .now i want to learn basic of mssql like syntax ... triggers/stored procedures/function etc........

for eg how i would write following code in mssql . is an trigger for inserting values into an another table written in oracle

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