Mega Code Archive

 

Categories / MSSQL Tutorial / Sequence Indentity

 

Returning an Identity Columns Seed and Incrementing Value

The IDENT_INCR  function displays the original increment value  for the IDENTITY column of a specific table or referencing view. SELECT IDENT_INCR('YourTableName') IdentIncr IdentSeed