generate random value in sql

SQL Server NEWSEQUENTIALID() function is used to generate incremental unique values of type uniqueidentifier.