IDENT_INCR Funtion
This function returns the increment value (returned as numeric (@@MAXPRECISION,0)) specified during the creation of an identity column in a table or view that has an identity column.
Syntax
IDENT_INCR ( 'table_or_view' )
Arguments
' table_or_view '
Is an expression specifying the table or view to check for a valid identity increment value. table_or_view can be a character string constant enclosed in quotation marks, a variable, a function, or a column name. table_or_view is char, nchar, varchar, or nvarchar.
Return Types
numeric
Exceptions
Returns NULL on error or if a caller does not have permission to view the object.In SQL Server, a user can only view the metadata of securables that the user owns or on which the user has been granted permission. This means that metadata-emitting, built-in functions such as IDENT_INCR may return NULL if the user does not have any permission on the object. For more information, see Metadata Visibility Configuration.
Examples
A. Returning the increment value for a specified table
The following example returns the increment value for the Person.Address table in the AdventureWorks database.
B. Returning the increment value from multiple tables
The following example returns the tables in the AdventureWorks database that include an identity column with an increment value.
Here is a partial result set.
Beginner School is optimized for learning. This is useful for getting basic knowledge with easiest way. Tutorials, examples are constantly reviewed to avoid errors, but we cannot warrant full correctness of all content. With the help of other reference book and website, the motive to provide you easiest way to understand the coding, technology and other things.....
Conversion Conversion Emoticon Emoticon