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

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

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