sql批量更新表中多字段为不同的值
1select convert(decimal(18,2),rand()), convert(decimal(18,2),rand())
2
3select newid()
4
5SELECT substring(LTrim(abs(checksum(newid()))),0,5)
6
7update tablename批量更新sql语句
8set  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)

版权声明：本站内容均来自互联网，仅供演示用，请勿用于商业和其他非法用途。如果侵犯了您的权益请与我们联系QQ:729038198，我们将在24小时内删除。