how to generate random unique value in sql server

SQL Server NEWID() function is a system function that  is used to generate a unique value of type uniqueidentifier.