SQL Server批量更新100-500间随机值

SQL Server批量更新100-500间随机值

declare @len int,@i int,@v int;
set @len=(select count(*) from Bbs_Post);--获取赋值范围的总长度
set @i=0; --逐一对行赋值的指针
while @i<@len
begin
declare @a int;
set @a=@i+100*cast(ceiling(rand()* 2) as int);
print @a
set @i=@i+1;
set @v=(select top 1 Post_Id from dbo.Bbs_Post  where  Post_BackCount<100 order by Post_id asc); --获取赋值范围中的随机值
update dbo.Bbs_Post set Post_BackCount = @a where Post_Id= @v
end