Sql Server Identity and DBCC CHECKIDENT

Sql Server Identity and DBCC CHECKIDENT Identity are basically use generate autonumber for a columns in sql server table.

seed : The first row value that is inserted into table. increment: incremental value that is added to identity value of previous record.  Suppose we needed to set start value is 100 with increment of 5 i.e next […]

Read More