By DevNet


2019-05-14 10:07:24 8 Comments

Does the NEWID() function generate UUID version 4?

Link to Wikipedia with versions

What is the situation with the NEWSEQUENTIALID() function?

Does the data always provide us with the UUID standard and version? Maybe it should be generated on the application side?

1 comments

@Thomas Franz 2019-05-14 10:20:14

Following to the Wikipedia page that you mentioned above (in the Database key section):

The NEWID function in Microsoft SQL Server version 4 Transact-SQL returns standard random version-4 UUIDs, while the NEWSEQUENTIALID function returns 128-bit identifiers similar to UUIDs which are committed to ascend in sequence until the next system reboot.

Related Questions

Sponsored Content

2 Answered Questions

[SOLVED] Change ID(int) to UUID

  • 2019-05-09 19:06:38
  • DevNet
  • 61 View
  • 0 Score
  • 2 Answer
  • Tags:   sql-server

1 Answered Questions

0 Answered Questions

Synchronisation of multiple databases with GUID type

2 Answered Questions

[SOLVED] Custom Sequences with SQL Server

1 Answered Questions

[SOLVED] SQL GUID or Identity in the Cloud

1 Answered Questions

2 Answered Questions

1 Answered Questions

4 Answered Questions

[SOLVED] Primary Key choice on table with unique identifier

4 Answered Questions

Sponsored Content