10 2010 档案

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 王培 阅读(397) 评论(0) 推荐(0)

导航