sqlserver 生成随机值

随机生成100以内的整数

select top 10 number,ceiling(rand(checksum(newid()))*100) from master.dbo.spt_values
where type='p'