Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2001
    Location
    FRANCE
    Posts
    25

    Unanswered: 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

    Gauthier

  2. #2
    Join Date
    Apr 2002
    Location
    VA
    Posts
    18
    Hi,

    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
    Deepak Khattar

  3. #3
    Join Date
    Oct 2001
    Location
    FRANCE
    Posts
    25
    that's it!

    thanks alot.

    Gauthier

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •