Generate Unique Number

SELECT CAST(RAND() * 1000000 AS INT) AS [RandomNumber]