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
Showing posts with label seed. Show all posts
Showing posts with label seed. Show all posts
Friday, February 24, 2012
Subscribe to:
Posts (Atom)