Question

What does the T-SQL command IDENT_CURRENT does?

Answer 1

The TSQL command IDENT_CURRENT returns the last identity value produced for a specified table or view. The last identity value created can be for any session and any scope.

Answer 2

The TSQL command IDENT_CURRENT returns the last identity value produced for a specified table or view.  The last identity value created can be for any session and any scope.

Answer 3

TSQL command IDENT_INCR returns the increment value mentioned during the formation of an identity column in a table or view that has an identity column.