My Blog
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
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment