Hi,
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
Gopinath
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()'
--
Happy Coding
Gopinath
No comments:
Post a Comment