sql server怎么生成1到100的随机数

1、登录sql server managment

3、执行select cast(ceiling(rand() * 100) as int)

5、执行select cast(floor(rand()*100) as int)