关于insert触发器

[Love001]

表：tab
-----------------------
|xingming | nianling |
-----------------------
|TOM | 20 |
-----------------------

我想实现：当用户向表中插入数据的时候，先判断表中是否存在改记录，如果存在则先删除该条记录后插入新的记录。
以下是我的SQL

alter trigger trig_upload_insert on tab for insert
as
begin
delete tab
from tab
where tab.xingming = inserted.xingming and tab.nianling = inserted.nianling
end
结果是连同将要插入的记录一起被删除了！
请教各位！

[yesyesyes]

应该用instead of insert触发器,不能用for insert

[lxd99423]

--最好是在插入之前作判断，实在不行的话，可以先全部删掉，再重插一次

alter trigger trig_upload_insert on tab for insert
as
begin
delete tab
from inserted
where tab.xingming = inserted.xingming and tab.nianling = inserted.nianling
--再插一次
insert tab select * from inserted
end

[lxd99423]

--这样还会更好一点
alter trigger trig_upload_insert on tab
instead of insert
as
begin
delete tab
from inserted
where tab.xingming = inserted.xingming and tab.nianling = inserted.nianling
--再插一次
insert tab select * from inserted
end

[Love001]

不好意思写错了

alter trigger trig_upload_insert on tab for insert
as
begin
delete tab
from tab,inserted
where tab.xingming = inserted.xingming
and tab.nianling = inserted.nianling
end

[Softlee81307]

不能寫在觸發中,應寫在insert 記錄的前面

[Love001]

可是我的客户端程序已经发布了

[chinacheng07]

學習

[FCU]

为什么不能写到触发器中呢?