Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: SQL MySQL
Need Differences on
@@IDENTITY vs SCOPE_IDENTITY() vs IDENT_CURRENT
 
Thanx on advance
~JK
Posted 30-Aug-12 23:14pm
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 3

The basic difference:
@@IDENTITY:
Returns the last identity value generated for any table in the current session, across all scopes.
 
SCOPE_IDENTITY
Returns the last identity value generated for any table in the current session and the current scope.
 
IDENT_CURRENT:
Returns the last identity value generated for a specific table in any session and any scope.
 
For more information about this, try google[^].
 

--Amit
  Permalink  
Comments
__TR__ at 31-Aug-12 7:46am
   
Simple explanation. 5ed!
_Amy at 31-Aug-12 7:59am
   
Thanks. :)
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

  Permalink  
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 2

hi,
 
@@IDENTITY will return you last inserted row value.
SCOPE_IDENTITY()will return your current table inserted value.
 
For Example,
I have one table 'ABC' in which i add one record. Its primary key value i will return and suppose that is 100. Now there is one trigger in inserting row of table ABC. Using that trigger suppose i am going in insert record in Table 'XYZ'. That row is suppose 200.
 
Now if you user @@IDENTITY then it will return 200. Last inserted value.
if you user SCOPE_IDENTITY()then it will give you 100.
 
I hope you will get idea after this example.
 
Thanks,
Viprat
  Permalink  

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
0 CPallini 365
1 Sergey Alexandrovich Kryukov 242
2 OriginalGriff 165
3 George Jonsson 159
4 Richard MacCutchan 110
0 OriginalGriff 6,344
1 Sergey Alexandrovich Kryukov 5,860
2 CPallini 5,135
3 George Jonsson 3,559
4 Gihan Liyanage 2,522


Advertise | Privacy | Mobile
Web04 | 2.8.140916.1 | Last Updated 31 Aug 2012
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100