重新编辑数据库字段唯一sql

declare @pid varchar(32)
declare @number int
declare @count int
set @number=1000000
set @count=1
declare cr_cursor --1.定义游标
cursor for
select p.id from Refcode p where number_ is null

open cr_cursor --2.打开游标

fetch From cr_cursor into @pid --3.提取游标

while @@fetch_status=0

begin

update Refcode set
number_ = @number+@count
where id = @pid

set @count+=1

fetch next From cr_cursor into @pid

end;

close cr_cursor --4.关闭游标
deallocate cr_cursor --5.释放游标

重新编辑数据库字段唯一sql

原文：https://www.cnblogs.com/wenjianli/p/13873116.html