Generate Random GUID (Uniqueidentifer) in SQL Server

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