Getting Identity of an Updated Row

• bigdave

  SSC Eights!

  Points: 853

  More actions

  November 20, 2001 at 10:31 pm

  #78123

  I want to return the identity for a row that was updated using an update statement.

  The update statement is as follows:

  UPDATE Answers

  SET InUse = @SessionID

  FROM (Select Top 1 AnswerID from Answers_Eligible) . . .

  I need the asnwerid for the updated record. @@Identity is only useful for inserts.

  Any suggestions appreciated.

  Thanks in advance

• Paul Ibison

  SSCertifiable

  Points: 5303

  More actions

  November 21, 2001 at 2:13 am

  #420269

  Could use "select top 1 identitycol from Answers_Eligible" after the update

  Paul Ibison

  Paul.Ibison@btinternet.com

  
  Paul Ibison
  Paul.Ibison@replicationanswers.com

• Steve Jones - SSC Editor

  SSC Guru

  Points: 738160

  More actions

  November 21, 2001 at 10:34 am

  #420283

  select @somvar = Top 1 AnswerID from Answers_Eligible

  Then use this in hte update and return it.

  Steve Jones

  steve@dkranch.net