CREATE TRIGGER Trigger1 ON Table1 FOR INSERT AS declare @f1 varchar(10) declare @f2 varchar(10) select @f1=I.Field1, @f2=I.Field2 from Inserted I if (select count(*) from table1 where Table1.Field1=@f1 and Table1.Field2=@f2)>0 begin delete from Table1 where Table1.Field1=@f1 and Table1.Field2=@f2 end
FOR INSERT
AS
declare @f1 varchar(10)
declare @f2 varchar(10)
select @f1=I.Field1,
@f2=I.Field2
from Inserted I
if (select count(*) from table1
where Table1.Field1=@f1
and Table1.Field2=@f2)>0
begin
delete from Table1
where Table1.Field1=@f1
and Table1.Field2=@f2
end