yiguxianyun的博客

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

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