You can minimize the holes in the sequence for Sybase by using the identity_gap attribute, available in 12.0 and later releases of Sybase:

create table foo (
   id    numeric(9) identity,
    ....
)
with identity_gap = 1
[download]

This would limit the potential gap in the sequence to 1, at some performance cost in the identity value generation.

Michael