newid() function | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

newid() function

What is the use of newid() function? It returns the value 1BE52EFE-0850-4834-8704-4622E39F0EEB. But this changes next time I run Select newid(). Is this similar to Random Function? Madhivanan

It provides a new GUID value each time it is called. Just like the IDENTITY property for numeric columns. When you do SELECT… ORDER BY NEWID() you actually have a good randomizer for returning random rows. —