Post reply

How to get the next ID

  • April 9, 2013 at 8:42 am

    #276299

    Hello,

    How would i find out the next ID from the current one i have selected, as at the moment i pass in a value which returns a row of information, inside that information i need to return the ID example

    1

    2

    3 --- Im currently select this one, also select 4 as the next ID

    4

    5

    ?

  • April 9, 2013 at 9:12 am

    #1604890

    DECLARE @ID int

    SET @ID = 3

    SELECT ID + 1 WHERE ID = @ID

    ?

    ______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply