Give an example of IDENT_CURRENT function.

 Posted by vishalneeraj-24503 on 2/3/2015 | Category: Sql Server Interview questions | Views: 330 | Points: 40
Answer:

Select Ident_Current('Employee_Master');

Output :- 2500 -> 2500 is the last row identity value.
Select Ident_Current('Project_Master');

Output :- 100 -> 100 is the last row identity value.


Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response