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