top button
Flag Notify
    Connect to us
      Facebook Login
      Site Registration Why to Join

Facebook Login
Site Registration

Difference Between SCOPE_IDENTITY() and @@IDENTITY

0 votes
16 views
Difference Between SCOPE_IDENTITY() and @@IDENTITY
posted Sep 28, 2015 by Sathaybama

Share this question
Facebook Share Button Twitter Share Button Google+ Share Button LinkedIn Share Button Multiple Social Share Button

1 Answer

0 votes

@@IDENTITY: Returns the last identity values that were generated in any table in the current session. @@IDENTITY is not limited to a specific scope.
SCOPE_IDENTITY(): Returns the last identity values that are generated in any table in the current session. SCOPE_IDENTITY returns values inserted only within the current scope.

answer Sep 28, 2015 by Shivaranjini
Contact Us
+91 9880187415
sales@queryhome.net
support@queryhome.net
#280, 3rd floor, 5th Main
6th Sector, HSR Layout
Bangalore-560102
Karnataka INDIA.
QUERY HOME
...