Generate Random GUID (Uniqueidentifer) in SQL Server June 08, 2016 To generate GUID (Uniqueidentifier) you can use this. SQL: select NEWID() Update Records which has null values in GUID Field with new guids SQL: update [YourTableName] set [YourColumnName]=NEWID() where [YourColumnName] is Null Read more