SQL生成随机数

declare @randnum tinyint
set @randnum =  cast(rand()*37 as tinyint)
select @randnum
posted @ 2011-02-25 18:42  rob_2010  阅读(98)  评论(0)    收藏  举报