SqlServer每行数据修改为不同的随机数

declare @i int 
set @i=1 
while @i<100 
   begin 
   update table set filed=(select 0.5+round((1.3-0.5)*rand(),1)) where id in (select top 1 id from table)
   waitfor delay '00:00:00.100'
   set @i=@i+1 
end

select 最小值+round((最大值-最小值)*rand(),保留小数位)

waitfor delay '00:00:00.100' 每隔100毫秒执行一次