Hi Friends,
           i need ur help for creating a update/delete trigger in sqlserver.i am having two tables.If i delete/update data of one table,that data should be stored in the second table.how to do this????

In oracle,i have written like this..

create or replace trigger updsal before
delete or update on sal for each row
begin
if updating then
insert into salaud values(:old.empno,:old.empname)
elseif
deleting then
insert into salaud values(:old.empno,:old.empname)
endif
end


how to do this in sqlserver????
please help me....
                         Thank You

__________________
sumith