Monday, November 21, 2016

NEW ID

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()

No comments:

Post a Comment