SQL 触发器 新建时删除相同数据

--create
alter trigger [dbo].[trigger_sqsj] 
on [dbo].[lctnrcrd] 
after INSERT as
BEGIN
declare @id char(50)
 select @id = (select top 1 id from [lctnrcrd] order by CONVERT(char(16),dlr,120) desc) 
 print @id 
 delete from [lctnrcrd] 
 --select * from [lctnrcrd] 
 where id = @id and 
 idowner+CONVERT(char(16),dlr,120) in 
(select idowner+CONVERT(char(16),dlr,120) from [lctnrcrd] where id not in(@id)) 
--select * from [lctnrcrd] order by CONVERT(char(16),dlr,120) desc
END
--select * from [lctnrcrd] order by CONVERT(char(16),dlr,120) desc

 

posted @ 2019-05-31 18:42  RainHouse  阅读(488)  评论(0编辑  收藏  举报