You're designing a new query that will eventually be used by a new software application. It's important that the application knows the id value of the last row that was inserted. Rather than re-run another query just to get the maximum id value, your friend has told you to include an inbuilt function. What might that function be?

 Posted by Bandi on 7/30/2014 | Category: Sql Server Interview questions | Views: 531 | Points: 40
Select from following answers:
  1. SCOPE_IDENTITY
  2. ROWCOUNT
  3. @@ROWCOUNT
  4. @@IDENTITY
  5. All Above

Show Correct Answer


Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response