declare @i int
set @i=1
while @i<20000
begin
update tr_table set num=ceiling(rand()*1000)+ 100 where flagDelete= '1' ' and ID=@i
set @i=@i+1
end
SQL批量修改某列随机数
最新推荐文章于 2024-08-02 11:56:02 发布
declare @i int
set @i=1
while @i<20000
begin
update tr_table set num=ceiling(rand()*1000)+ 100 where flagDelete= '1' ' and ID=@i
set @i=@i+1
end