sql - Best way to get identity of inserted row? - Stack Overflow

SCOPE_IDENTITY returns the last identity value generated for any table in the current session and the current scope. .... if you insert several rows with an INSERT-SELECT, you would ...

stackoverflow.com