yiguxianyun的博客

原创 SQL找出重复记录然后重新编号

DECLARE @i intSET @i=0UPDATE dbo.XJ1SET @i=@i+1,数据表编号='KKk'+cast(@i as varchar(20)) where 数据表编号 in (select 数据表编号 from dbo.XJ1 group by 数据表编号 having count(1) >= 2)