Select from following answers:- @@Identity returns the Last identity value generated in any table in the current session.
- After an Insert,Select InTo,or bulk copy statement completed,@@Identity contains the last identity value generated by the statement.
- If the statement did not affect any tables with identity columns,@@Identity returns NULL.
- If multiple rows are inserted,generating multiple identity values,@@Identity returns the last identity value generated.
- All Above
Above all statement is correct about @@Identity function.As we know that the scope of the @@Identity function is within the local server on which it is executed.
Select @@Identity;
Show Correct Answer
Asked In: Many Interviews |
Alert Moderator