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)
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)