Archive
Posts Tagged ‘newid()’
Auto generate new GUID for ‘uniqueidentifier’ column in SQL Table
June 30, 2014
1 comment
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