create trigger test on 表A for insert,update as declare @id int if exists(select id from insert) begin select @id=id from insert end if update(aid) begin update 表B set bbb=a.bbb from 表B,表A a where 表B.bid=@id end
---like this create trigger A_insert on A for insert as begin update B set bbb=x.bbb from B,inserted x where b.bid=x.bid and x.aaa='1'end
create trigger test on 表A
for insert,update
as
declare @id int
if exists(select id from insert)
begin
select @id=id from insert
end
if update(aid)
begin
update 表B set bbb=a.bbb from 表B,表A a where 表B.bid=@id
end
create trigger A_insert
on A
for insert
as
begin
update B set bbb=x.bbb
from B,inserted x
where b.bid=x.bid and x.aaa='1'end