Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
NEWID (SQL Server Compact)
Collapse the table of content
Expand the table of content

Creates a unique value of type uniqueidentifier.



NEWID ( )


uniqueidentifier

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
Show:
© 2015 Microsoft