34,576
社区成员
发帖
与我相关
我的任务
分享
create trigger t_update on A
after update
as
begin
update B set B.B_2=case when A.A_2='UP' then 'UUUUU'
when A.A_2='DOWN' then 'DDDDD'
when A.A_2='UP' and B.B_2='UUUUU' then 'FFFF'
when A.A_2='DOWN' and B.B_2='DDDDD' then 'GGGG'
end
from B,A
where B.B_1=A.A_1
end
create trigger t_update on A
after update
as
begin
update B set B.B_2=case when i.A_2='UP' then 'UUUUU'
when i.A_2='DOWN' then 'DDDDD'
when i.A_2='UP' and B.B_2='UUUUU' then 'FFFF'
when i.A_2='DOWN' and B.B_2='DDDDD' then 'GGGG'
end
from B,inserted i
where B.B_1=i.A_1
end