Identity Column  
Author Message
DrVertigo





PostPosted: Wed Oct 15 03:23:59 CDT 2003 Top

SQL Server Developer >> Identity Column

Hi,
If the identity column grows to the maximum integer value, how to deal with?

Thanks in advance
Frank

SQL Server136  
 
 
Andrew





PostPosted: Wed Oct 15 03:23:59 CDT 2003 Top

SQL Server Developer >> Identity Column Frank,

If using int (or smaller ), use bigint or decimal so it does not every grow to maximum.
( Or set the seed negative to double useable numbers )
Generate your own ( ie dont use identity ),
and reuse numbers ( unless you really do have 2Billion + rows concurrently ?)

Regards
AJ


> Hi,
> If the identity column grows to the maximum integer value, how to deal with?
>
> Thanks in advance
> Frank
>
>


 
 
Frank





PostPosted: Wed Oct 15 03:38:06 CDT 2003 Top

SQL Server Developer >> Identity Column Thanks Andrew,
I do choose using the self defined int column with triggers to control the
logic. And want to know what the others using.
And even though there is few chance that the integer column may grow so
large as to the integer maximum, if using the identity property, I have to
deal with it to avoid any hidden bug.



> Frank,
>
> If using int (or smaller ), use bigint or decimal so it does not every
grow to maximum.
> ( Or set the seed negative to double useable numbers )
> Generate your own ( ie dont use identity ),
> and reuse numbers ( unless you really do have 2Billion + rows concurrently
?)
>
> Regards
> AJ
>


> > Hi,
> > If the identity column grows to the maximum integer value, how to deal
with?
> >
> > Thanks in advance
> > Frank
> >
> >
>
>