Thursday, 22 February 2018

how to change identity value in sql server

create table checkIdentity
(
  Id int Identity(1,1),
  Name varchar(50)
)

select * from checkIdentity

insert into checkIdentity(Name) values('A'),('B'),('C'),('D')




DBCC checkIdent('checkIdentity',reseed,100)


insert into checkIdentity(Name) values('F')



No comments:

Post a Comment