Home Forums SQL Server 2008 T-SQL (SS2K8) NEWID() - How does it work? RE: NEWID() - How does it work?
Lynn Pettis
SSC Guru
Points: 442467
More actions
February 22, 2013 at 9:08 pm
#1590576
I haven't tried, but are you sure you can convert a uniqueidentifier to a bigint?
As to ordering by a uniqueidentifier, it sorts in ascending or descending order as if it is converted to a CHAR(36) value, or at least that is my experience with them.