Export (0) Print
Expand All

NEWID

SQL Server 2000

Creates a unique value of type uniqueidentifier.

Syntax
NEWID ( ) 
Return Types

uniqueidentifier

Examples

The following example returns a uniqueidentifier value that is inserted into a table using the NEWID function.

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

Show:
© 2014 Microsoft