删除重复数据的触发器.sql

CREATE trigger [dbo].[tri_Table_Ins]
on [dbo].[T_tab]
for insert
as
declare @count int
Select @count=count(*) From [dbo].[T_tab] T,Inserted A where A.Title=T.Title

if @count >1
begin
Delete From [dbo].[T_tab]  where PKID in (select PKID from Inserted)
end