sql default value 0 autoincrement code example

Example 1: sql server set default value equal to auto increment

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

Example 2: sql server set default value equal to auto increment

create table t (
    id int identity(100, 1) primary key,
    . . .
);