使用TRIGGER:
create trigger t_line for update
update test set 状态 = '删除' where id = deleted.id
update test set 状态 = '插入' where id = inserted.id
create trigger t_line for update
update test set 状态 = '删除' where id = deleted.id
update test set 状态 = '插入' where id = inserted.id
ON line
FOR INSERT, UPDATE
as
update test set... from deleted where id=refid
delete操作会去触发一下trigger,insert也会去触发一下trigger,他们又不会在一起做?
create trigger tu_line for update
update test set 状态 = '删除' where id = deleted.id
update test set 状态 = '插入' where id = inserted.idcreate trigger td_line for delete
update test set 状态 = '删除' where id = deleted.idcreate trigger ti_line for insert
update test set 状态 = '插入' where id = inserted.id
但是我就想求delete和insert所影响到的REFID,然后统一去修改这些REFID的状态?
update test set 状态 = '删除' where id = deleted.idcreate trigger ti_line for insert
update test set 状态 = '插入' where id = inserted.id
你可以用全局临时表来达到目的!
例如:
create trigger td_line for delete
if ... and object_id('tempdb..##全局临时表') is null
select * into ##全局临时表 from deleted update test set 状态 = '删除' where id = deleted.idcreate trigger ti_line for insert
if ... and object_id('tempdb..##全局临时表') is not null
update test set 状态 = '更新' where id = inserted.id
else
update test set 状态 = '插入' where id = inserted.id---你要根据你的实际情况来做!