往数据库中循环插入自增长的数据，但不是自增长列

 declare @no varchar(50),@ii int,@cw varchar(50),@qw varchar(50),@newid varchar(100)
set @ii = 1
declare cur cursor
for select NEWID From bi_space
open cur
fetch next from cur into @newid
while @@fetch_status = 0
begin
 Set @no = 'GW' + substring('000' + Convert(varchar,@ii),len('000' + Convert(varchar,@ii)) - 2,3)
 Update bi_space Set SP_ID = @no Where newid = @newid
 Set @ii = @ii + 1
 fetch next from cur into @newid
end
close cur
deallocate cur