I have an smallint field which can have maximum of 6000 value.
Everytime I insert record I want to insert the next available number but not the max(field1) + 1.
Because I might be deleting some records so there would be some unused numbers between 1 - 6000 which were not allocated yet.
Is there any single command or I have to use cursor and check out the next value with previous value.
Everytime I insert record I want to insert the next available number but not the max(field1) + 1.
Because I might be deleting some records so there would be some unused numbers between 1 - 6000 which were not allocated yet.
Is there any single command or I have to use cursor and check out the next value with previous value.