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

 select convert(decimal(18,2),rand()), convert(decimal(18,2),rand())

 select newid()

 SELECT substring(LTrim(abs(checksum(newid()))),0,5)

 update tablename
set FA=100,
FB=ROUND(RAND(substring(LTrim(abs(checksum(newid()))),0,6)) * 50, 0),
FC=ROUND(RAND(substring(LTrim(abs(checksum(newid()))),0,6)) * 50, 0)
上一篇:将HDMI无线化,毫米波无线投屏器见识一下


下一篇:互联网寒冬公司倒闭后,Android架构师成长路线