SCOPE_IDENTITY which column it will return

• ajaysanhotra

  SSC-Addicted

  Points: 468

  More actions

  November 20, 2011 at 11:16 pm

  #98159

  i have two identity column col1 and col2 in my table

  i have written an SP in which on new row addition i want the latest ID so that i could refer that to another table

  my query when i write the query

  "SELECT @Latest_id = SCOPE_IDENTITY()"

  which value i will get Col1 or Col2

  actaully i want Col2 value, should i need to change the query to get the desired result

• spaghettidba

  SSC Guru

  Points: 105732

  More actions

  November 21, 2011 at 1:40 am

  #1410522

  Duplicate post.

  Replies here please: http://www.sqlservercentral.com/Forums/FindPost1209021.aspx

  -- Gianluca Sartori