CODE EXAMPLE FOR SQL

sql server set default value equal to auto increment

dbcc checkident ('t', reseed, 100);