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
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment