MYSQL与MSSQL的随机数
摘要：生成原理，生成A-B之间的随机数(纯数字):SELECTFLOOR(A+(RAND() * (B-A+1)))MSSQL批量生成随机数:SELECT CEILING(100*RAND(CHECKSUM(NEWID()))) FROM Table1SELECT FLOOR(100*RAND(CHECKSUM(NEWID()))) FROM Table1MYSQL批量生成随机数:SELECT FLOOR(200+(RAND(UUID()) * 351)) FROM Table1简单解析：floor(100.9) = 100floor 返回小于或等于所给数字表达式的最大整数。ceiling(100.
阅读全文
posted @ 2010-10-27 12:39
