Friday, February 24, 2012

obtain the next Identity seed?

Hi,
I'm using identity seed (increment by 1) as primary key in my tables.
Is there any way to determine what will be the next available identity for a specified table?
Thanks for the info
GauthierHi,

In 2000 you can use IDENT_CURRENT('table name ') + 1 to get next possible value. but in multi user env , need to check ...

best of luck|||that's it!

thanks alot.

Gauthier

No comments:

Post a Comment