sql生成某范围内的随机数

rand() 返回从 0 到 1 之间的随机 float 值。 select ceiling(rand()*1000)

=======================

declare @n int,@m int
set @n=1
set @m=10
declare @ids varchar(max)
set @ids = ''
while @n<=@m
begin
    set @ids = @ids + ',' + REPLACE(str(ceiling(rand()*1000)),' ','')   
    set @n=@n+1
end
if (@ids!='')
set @ids = '0'+@ids
print @ids