Give an example of IDENT_CURRENT function.

Posted by vishalneeraj-24503 on 2/3/2015 | Category: Sql Server Interview questions | Views: 1190 | 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

Bookmark It

< Previous : Which statement is correct about NewId() function?

Next > : Which statement is True about IDENT_CURRENT functi ...

More Interview Questions by vishalneeraj-24503

Latest Interview Questions