Wednesday, January 19, 2011

Random Number SQL

From http://goo.gl/vzyje

-- random integer BETWEEN 4 AND 6 - [4, 6]
SELECT 4 + CONVERT(INT, (6-4+1)*RAND())

No comments: