Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2011
    Posts
    15

    Question Unanswered: Getting the next identity value to be used in a table

    Hi,

    Can some one help me with getting a next identity value to be used in a table.
    I need to get the identity value(the auto-increment value)before performing an insert into the table.

    Any immediate help on this is highly appreciated.

    Regards,
    Jeevana.

  2. #2
    Join Date
    May 2011
    Posts
    28
    Hi,
    You can use next_identity function to retrieve the value in ASE 15.5.
    Code:
    select next_identity (<table Name>)
    go

  3. #3
    Join Date
    Jul 2011
    Posts
    15

    Red face

    Could u pls let me know if there is there is any similar function in SQL Anywhere10.

Posting Permissions

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