sql select 每一行生成一个随机数

SELECT ABS(CAST(CAST(NEWID() AS VARBINARY) AS INT)) AS [RandomNumber]
select  (ABS(CHECKSUM(NewId())) % 14 +1)
select  floor(15 * RAND(convert(varbinary, newid()))) magic_number
select  cast(RAND(CHECKSUM(NEWID()))*15 as int)
SELECT BINARY_CHECKSUM (NEWID())

 

posted @ 2015-05-25 17:20  HETUAN  阅读(450)  评论(0)    收藏  举报