Creates a GUID that is greater than any GUID previously generated by this function on a specified computer.
If privacy is a concern, do not use this function. It is possible to guess the value of the next generated GUID, and therefore access data associated with that GUID.
NEWSEQUENTIALID ( )
NEWSEQUENTIALID() can only be used with DEFAULT constraints on table columns of type uniqueidentifier. For example:
CREATE TABLE myTable (ColumnA uniqueidentifier DEFAULT NEWSEQUENTIALID())
When NEWSEQUENTIALID() is used in DEFAULT expressions, it cannot be combined with other scalar operators. For example, you cannot execute the following:
CREATE TABLE myTable (ColumnA uniqueidentifier DEFAULT dbo.myfunction(NEWSEQUENTIALID()))
In the previous example,
myfunction() is a scalar user-defined scalar function that accepts and returns a
NEWSEQUENTIALID() cannot be referenced in queries.
The GUIDs generated by NEWSEQUENTIALID() are unique only within a particular computer if the computer does not have a network card.
You can use NEWSEQUENTIALID() to generate GUIDs to reduce page contention at the leaf level of indexes.
Help and Information
14 April 2006