SELECT CAST(RAND()*100 AS INT)
SELECT substring(convert(nvarchar(36),newid()),1,5)
SELECT CAST(rand()*9999+1000 AS INT)
SELECT CAST(rand()*9999+1000 AS INT)
select abs(checksum(newid()) % 100000)
SELECT round( RAND( (DATEPART(mm, GETDATE()) * 100000 )+ (DATEPART(ss, GETDATE()) * 1000 )+ DATEPART(ms, GETDATE()) )*10000,0)
SQL取随机数
最新推荐文章于 2020-06-23 17:13:07 发布