sql 批量更新表中多字段为不同的值

 1 select convert(decimal(18,2),rand()), convert(decimal(18,2),rand())
 2 
 3 select newid()
 4  
 5 SELECT substring(LTrim(abs(checksum(newid()))),0,5)
 6 
 7 update tablename 
 8 set  FA=100,
 9 FB=ROUND(RAND(substring(LTrim(abs(checksum(newid()))),0,6)) * 50, 0),
10 FC=ROUND(RAND(substring(LTrim(abs(checksum(newid()))),0,6)) * 50, 0)
【推广】 免费学中医，健康全家人
原文地址：https://www.cnblogs.com/ziranquliu/p/5739847.html