SQL 触发器 新建时删除相同数据
时间：2021-07-01 10:21:17
帮助过：7人阅读
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
SQL 触发器 新建时删除相同数据
标签：bsp insert pre delete class esc 数据 down order
