What is the difference between scope_identity() and current_identity()?

 Posted by Kmandapalli on 1/20/2014 | Category: C# Interview questions | Views: 969 | Points: 40
Answer:

Both of them are similar and they will return the last identity value generated in the table.
The difference is that scope_identity() returns the identity value that is currently in scope.


Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response