NEWID

Description

Creates a unique value of type uniqueidentifier. (NEWID in Transact-SQL).

Sample Source Pattern

Syntax

SQL Server

NEWID ( )  

Snowflake SQL

Snowflake SQL Documentation

UUID_STRING()

Examples

Outputs may differ because it generates a unique ID in runtime

SQL Server

Code:

IN -> SqlServer_01.sql

SELECT NEWID ( ) AS ID;

Result:

+------------------------------------+
|ID                                  |
+------------------------------------+
|47549DDF-837D-41D2-A59C-A6BC63DF7910|
+------------------------------------+

Snowflake SQL

Code:

OUT -> SqlServer_01.sql

SELECT
UUID_STRING( ) AS ID;

Result:

+------------------------------------+
|ID                                  |
+------------------------------------+
|6fd4312a-7925-4ad9-85d8-e039efd82089|
+------------------------------------+