Home / Software / Tips and Tricks / How to updadate GUID in SQL Server table.

How to updadate GUID in SQL Server table.

Updated:  06/27/2012 06:06 AM
Author:  Shiju Mathews

Status:    Resolved.


The GUID is a 16-byte binary data type unique across the server. The GUID can be logically grouped into the following subgroups:

4byte-2byte-2byte-2byte-6byte.
The standard textual representation is {12345678-1234-1234-1234-1234567890AB}.
It having 36 Characters in string length.

If you want to generate a new Guid (uniqueidentifier) in SQL server the you can simply use the NEWID() function