Which statement is(are) TRUE about @@Identity function?

 Posted by Vishalneeraj-24503 on 3/23/2015 | Category: Sql Server Interview questions | Views: 1112 | Points: 40
Select from following answers:
  1. @@Identity returns the Last identity value generated in any table in the current session.
  2. After an Insert,Select InTo,or bulk copy statement completed,@@Identity contains the last identity value generated by the statement.
  3. If the statement did not affect any tables with identity columns,@@Identity returns NULL.
  4. If multiple rows are inserted,generating multiple identity values,@@Identity returns the last identity value generated.
  5. All Above

Show Correct Answer


Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response