如何写一个触发器,实现这个功能呢,我写的是这样的CREATE TRIGGER update_zt
on ys_yy_d
FOR UPDATE
AS
declare @zt1 int
select @zt1=zt
from inserted
if @zt1=1
begin
insert into zyc select * from inserted
delete from ys_yy_d where exists (select * from inserted)--把表中跟新过的行删除
但是这样写的结果却是把所有的表都删除了,为什么会这样呢insert触发器 deleteupdate
on ys_yy_d
FOR UPDATE
AS
declare @zt1 int
select @zt1=zt
from inserted
if @zt1=1
begin
insert into zyc select * from inserted
delete from ys_yy_d where exists (select * from inserted)--把表中跟新过的行删除
但是这样写的结果却是把所有的表都删除了,为什么会这样呢insert触发器 deleteupdate
delete from ys_yy_d where 主键 in (select 主键 from inserted)
我的这样理解是对的吗