Difference between @@IDENTITY, SCOPE_IDENTITY, IDENT_CURRENT

IntroductionIn most of  our application scenario we need to get latest inserted row information through SQL query. And for that we have multiple options like @@IDENTITY, SCOPE_IDENTITY, IDENT_CURRENT All three functions return last-generated identity values. However, the scope and session on which last is defined in each of these functions differ. Compare  @@IDENTITY : It returns the last