Auto generate new GUID for ‘uniqueidentifier’ column in SQL Table
If you a have a column of type ‘uniqueidentifier’ in your SQL table, and you want to auto generate a new Guid every time when you insert a record, you can use the ‘Default Value or Binding’ property of ‘Column Properties’.
Set Default Value or Binding = newid()
🙂
Categories: SQL
newid(), SQL, uniqueidentifier
Thank you!