Everything about SQL Identity

create table players

( id int identity(1,1) not null,

name varchar(50))

 

insert into players values('vaaibhav')

insert into players values('vaaav')

 

select * from players

 

dbcc checkident (players, noreseed)

 

dbcc checkident (players, reseed, 10)

 

insert into players values('vav')

 

select * from players

 

 

create table experts

( id int identity(2,2) not null,

name varchar(50))

 

insert into experts values('vaaibhav')

insert into experts values('vaaav')

 

select * from experts