IDENT_INCR function returns the indrement value of an identity column specified while creating a table or view.
Syntax of IDENT_INCR Function :
IDENT_INCR ('table_or_view')
table_or_view is a table or view name. It can be of type char, nchar, varchar or nvarchar
Return type of IDENT_INCR function is a numeric.
Examples of IDENT_INCR Function :
Example 1 : Use of IDENT_INCR function in select clause
SELECT IDENT_INCR ('User')
Output
1
Above example returns increment value 1 of an identity column in User table.