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...)