Reset the SQL Server table's self-increment column, and let the self-increment column count again

SQL's self-increment column is very easy to use, just the development process once deleted data, the identity column is not continuous write up is also very depressed, so looked up the identification column reset method found can be divided into three kinds:

---Delete the original table data and reset the self-increment column
TRUNCATE TABLE tablename--truncate mode you can also reset the self-increment field
--Resets the table's self-increment field, preserving the data
DBCC checkident (tablename,reseed,0)
--set allow explicit insertion of self-increment columns
SET IDENTITY_INSERT TableName on

--Of course insert is complete remember to set do not allow explicit insertion of self-increment columns
SET IDENTITY_INSERT TableName OFF

Reset the SQL Server table's self-increment column, and let the self-increment column count again