 Awangku wrote:
Yup.. that helps a lot. It also means I can't use identity in all of my tables since there'll be quite a number of deleting and adding new records to the tables once the whole project goes live.
|
It shouldn't matter. There's nothing wrong with having gaps in the autonumber primary key.
If you need a field which doesn't have gaps then you can create this yourself through code. But you need to first ask the question - 'Why do you need a field withough gaps?'
If its just to keep a count of the number of records you can do this on the fly when you output your data..no need to actually store it in the database itself.
Cheers,
Andrew
Edited by Bunce
Topic Options
Post Options
Thanks(0)
