SCOPE_IDENTITY() to return the identity of the recently added row in your INSERT SQL Statement or Stored Procedure.
If we our requirement is to take the latest added row from table then we should have to use
It returns the most recently created identity for your current connection. It may not be the identity for the recently added row in a table.
So it will be better to use SCOPE_IDENTITY() to fetch the latest row added in table.
If you know any more difference then please share with me.