Listing 1: Assigning Unique GUIDs by Using NewSequentialId() and NewId()

USE tempdb

DECLARE @InsertedRowCount int
SET @InsertedRowCount = 0

CREATE TABLE OrderByTestNewSequentialID
(
RowNumber			int identity
,NewSequentialIDCol uniqueidentifier DEFAULT NEWSEQUENTIALID()
,NewIdCol			uniqueidentifier DEFAULT NEWID()
)

-- Create five rows for testing.
WHILE @InsertedRowCount <= 5
BEGIN
	INSERT INTO OrderByTestNewSequentialID DEFAULT VALUES
	SET @InsertedRowCount = @InsertedRowCount +1
END

-- Return the rows sorted by NewSequentialIDCol.
SELECT * FROM OrderByTestNewSequentialID ORDER BY NewSequentialIDCol

-- Return the rows sorted by NewIDCol.
SELECT * FROM OrderByTestNewSequentialID ORDER BY NewIDCol