GUID in .NET & SQL Server

You can create a GUID in .NET using the System.GUID

the same can be created in SQL Server

SELECT NEWID()

if you want to get records in random order you can try this.

SELECT * FROM SysObjects ORDER BY NEWID()