Saturday, 20 August 2016

Autogenerate GUID in SQL Table

Today I was working on SQL Table creation and I had a requirement to generate a UniqueIdentifier automatically whenever a record is inserted into the table.

We can achieve this requirement by having Column datatype as 'UniqueIdentifier' and Default Value or Binding of the column property should be set to 'newid()'
Hope this helps.
Happy Coding


No comments:

Post a Comment