在SQL中获取随机数-rand() 2020/2/21 MS SQL 0 Comments 1,088 Views 4 Times 1、随机小数: select rand() 2、随机0-99之间的的整数: select cast( floor(rand()*100) as int) 3、随机1-100之间的整数: select cast(ceiling(rand() …