NEWID() Generating Random Numbers in SQL-Server

select newid()

select abs(checksum(newid())) as number 

select  abs(cast(cast(newid() as varbinary(10)) as int)) as number 

More info http://sqlserver-qa.net/blogs/t-sql/archive/2007/10/10/2422.aspx