Trigger

[sumithsumith]

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

[kenobewan]

Here is an article that may help:
ObjectDataSource

[prakashramamoorthy]

Hi,

whether u r updating or inserting the records in Sql server it will store the backup in INSERTED table. you can access this table in trigger and can do the insertion in the second table.

rgds,
RP

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