sql 随机数高效率算法

Declare @d Datetime
Set @d=getdate()
SELECT Top 1* FROM [user_info]
WHERE 0.01 >= CAST(CHECKSUM(NEWID(), [id]) & 0x7fffffff AS float) / CAST (0x7fffffff AS int)
Select [语句执行花费时间(毫秒)] = Datediff(ms,@d,Getdate())

原文地址:https://www.cnblogs.com/zcm123/p/2608438.html