NEWID (SQL Server Compact)

Creates a unique value of type uniqueidentifier.

Syntax

NEWID ( )

Return Value

uniqueidentifier

Example

The following example returns a uniqueidentifier value that is added to a table by using the NEWID function.

CREATE TABLE myTable(GuidCol uniqueidentifier, NumCol int)
INSERT INTO myTable Values(NEWID(), 4)
SELECT * FROM myTable