Difference on @@IDENTITY , SCOPE_IDENTITY() & IDENT_CURRENT

Have a look at the follow blog http://blog.sqlauthority.com/2007/03/25/sql-server-identity-vs-scope_identity-vs-ident_current-retrieve-last-inserted-identity-of-record/[^]. You'll find your answer there.

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