SQL SERVER – 2005 – Difference and Similarity Between NEWSEQUENTIALID() and NEWID() | Journey to SQL Authority with Pinal Dave

NEWSEQUENTIALID() and NEWID() both generates the GUID of datatype of uniqueidentifier. NEWID() generates the GUID in random order whereas NEWSEQUENTIALID() generates the GUID in sequential order. Let us see example first demonstrating both of the function. USE AdventureWorks; GO ----Create Test Table for with default columns values CREATE TABLE TestTable (NewIDCol uniqueidentifier DEFAULT NEWID(), NewSeqCol… Continue Reading...

Source: SQL SERVER – 2005 – Difference and Similarity Between NEWSEQUENTIALID() and NEWID() | Journey to SQL Authority with Pinal Dave