if exists(select 1 from tb where 字段1='ssdf') begin delete tb where 字段1='ssdf' insert tb select 'ssdf','sdffds',..... end else insert tb select 'ssdf','sdffds',.....
先删除后添加,不用判断,因为delete里面有where delete from 表A where id=newid insert into 表A values(newid, ...)
CREATE TRIGGER TriggerN ON Table for INSERT AS if exists(select 字段1 from Table where 字段1=(select 字段1 from inserted)) delete from Table where 字段1=(select 字段1 from inserted)insert into Table select * from inserted
begin
delete tb where 字段1='ssdf'
insert tb select 'ssdf','sdffds',.....
end
else
insert tb select 'ssdf','sdffds',.....
delete from 表A where id=newid
insert into 表A values(newid, ...)
for INSERT
AS
if exists(select 字段1 from Table where 字段1=(select 字段1 from inserted)) delete from Table where 字段1=(select 字段1 from inserted)insert into Table select * from inserted