SQL SERVER触发器问题？

[xyz_no1]

表Table1(主键为Field1,Field2)，在插入记录前，如果存在这条记录的话，先删除旧的记录后，再删除，请问，这个触发器该怎么写？
我原来是这么写，可得不到所要的结果
CREATE TRIGGER Trigger1 ON Table1
FOR INSERT
AS
declare @f1 varchar
declare @f2 varchar
select @f1=I.Field1,
@f2=I.Field2
from Inserted I
delete from Table1
where Table1.Field1=@f1
and Table1.Field2=@f2

[zgamer]

up

[zhangshzh]

同意progame

[xyz_no1]

up

[xyz_no1]

谁知道的话，请帮忙，全部分相送

[progame]

你改一种方法试试

[progame]

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