Select from following answers:- It function returns the Last Identity Value for a Table in any session and any scope.
- It is not affected by scope and session,it only depends on a particular table and returns that table related identity value which is generated in any session or scope.
- It also returns an Integer values.
- It can retrieve Last Inserted value even we switch to new query window.
- All Above
Above all statements are correct about IDENT_CURRENT function.IDENT_CURRENT is also an in-built Sql Server function which produces the Last Identity value for a Table.
Syntax:-
IDENT_CURRENT('table_name');
Show Correct Answer
Asked In: Many Interviews |
Alert Moderator