» Best Practices
» identity (RSS)
Sorry, but there are no more tags available to filter with.
In my last post in this series,
about inconsistent naming conventions. This time I want to talk about a few of the assumptions people make when using IDENTITY columns, and what kind of trouble they can cause.
IDENTITY will prevent gaps
A lot of people choose IDENTITY as their ''primary key'' and expect it to leave no gaps - ...