Scope_identity and current _identity both are similar and it will return the last identity value generated in the table. Scope_Identity will return the identity value in table that is currently in scope