22,209
社区成员
发帖
与我相关
我的任务
分享
create trigger tr_yb_zy_fyhzls on yb_zy_fyhzls
for insert,delete
as
begin
-- 每插入一条进去yb_zy_fyhzls,就触发把这条记录插到另一张表A
if exists(select 1 from inserted) and not exists(select 1 from deleted)
begin
insert into 表A([字段列表])
select [字段列表] from inserted
end
-- 当yb_zy_fyhzls的一条记录被删,就触发把这个相应在A的记录的字断“czjc”改为F
if not exists(select 1 from inserted) and exists(select 1 from deleted)
begin
update a
set a.czjc='F'
from 表A a
inner join deleted b on a.blh=b.blh and a.zycs=b.zycs
end
end