- Returns the last identity produced on a connection
- Returns the last identity value produced on a connection and by a statement in the same scope.
- This return the last identity value you explicitly created, rather than any identity created by any trigger.
- Returns the last identity value produced in a table, regardless of connection. It also accounts so roll backed item let say if you have 2 rows insert and two rolled back it will contain 4 instead of 2.