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
