create trigger dbo.tri_Test on Test for insert,update,delete as if update(a) ................ else rollback Go
try: create table A ( id int, T_name varchar(10) )create table B ( id int, T_name varchar(10) )CREATE TRIGGER TEMP_SC on A INSTEAD OF Insert as if exists (select 1 from A,inserted I where A.id=I.id and A.T_name<> I.T_name) insert B select * from inserted where id in (select I.id from A,inserted I where A.id=I.id and A.T_name<> I.T_name ) insert A select * from insertedCREATE TRIGGER TEMP_SC1 on A INSTEAD OF update as if exists (select 1 from A,inserted I where A.id=I.id and A.T_name<> I.T_name) insert B select * from inserted where id in (select I.id from A,inserted I where A.id=I.id and A.T_name<> I.T_name ) update A set T_name=I.T_name from A T,inserted I where T.id=I.id
on Test for insert,update,delete
as
if update(a)
................
else
rollback
Go
create table A
(
id int,
T_name varchar(10)
)create table B
(
id int,
T_name varchar(10)
)CREATE TRIGGER TEMP_SC on A
INSTEAD OF Insert
as
if exists (select 1 from A,inserted I where A.id=I.id and A.T_name<> I.T_name)
insert B select * from inserted where id in (select I.id from A,inserted I where A.id=I.id and A.T_name<> I.T_name )
insert A select * from insertedCREATE TRIGGER TEMP_SC1 on A
INSTEAD OF update
as
if exists (select 1 from A,inserted I where A.id=I.id and A.T_name<> I.T_name)
insert B select * from inserted where id in (select I.id from A,inserted I where A.id=I.id and A.T_name<> I.T_name )
update A set T_name=I.T_name
from A T,inserted I
where T.id=I.id