Identity Field

[Muhammad Qasim Pasta]

If we have an identity field wit data type of BigInt ... but at certain stage it will overflow ... then what will happen and how can prevent for such scenario?

[Krish KP]

use decimal data type this allows max value i.e. 38 digits

Regards KP

[Muhammad Qasim Pasta]

But at certain stage ... it could overflow too! then? for example.. in case of Amazon or any service like that...

[Krish KP]

every s/w has its own limitations. in SQL Server 2000 decimal is the one which can be used max digits pls check whether your number is more than 38 digits or in how many yrs it is going to reach this limit. or use a char/varchar data type which allowes you even more. or else take a new table.

Regards KP