Random Number in Sql Server

Random Number in Sql Server
--------------------------

declare  @RandomNumber bigint
SELECT  @RandomNumber= CAST(RAND() *

100000000 AS bigint)
print @RandomNumber