|
|
|
Author |
Message |
DrVertigo
|
Posted: 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
|
Posted: 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
|
Posted: 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
> >
> >
>
>
|
|
|
|
|
|
|