which inbuilt function can be used to know the id value of the last row that was inserted, rather than re-run another query just to get the maximum id value ?

 Posted by Bandi on 8/29/2017 | Category: Sql Server Interview questions | Views: 1360 | Points: 40
Select from following answers:
  1. ROWCOUNT
  2. @@IDENTITY
  3. @@ROWCOUNT
  4. SCOPE_IDENTITY
  5. All Above

Show Correct Answer


| Alert Moderator 

Comments or Responses

Login to post response