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())

浙公网安备 33010602011771号