Which of the following is used to get the identity of the most recently inserted row?

86.

SELECT SCOPE_IDENTITY()

SELECT LAST_ID()

SELECT SCOPE_ID()

SELECT LAST_IDENTITY()

Returns the last identity value inserted into an identity column in the same scope. A scope is a module: a stored procedure, trigger, function, or batch. Therefore, two statements are in the same scope if they are in the same stored procedure, function, or batch.