1、如果仅仅是指定值插入,可用以下语句,临时取消
SET IDENTITY_INSERT TableName ON
INSERT INTO 。。。。。。。。。。。。
SET IDENTITY_INSERT TableName OFF
2.自己测试的结果:
create table Stutent
( SName varchar(100))
--新增,修改列
Alter table Stutent Drop Column id
Alter table Stutent Add id Int IDENTITY(1,1)
--OK
dbcc checkident('Stutent',reseed,5)
insert into Stutent values('qqq')
--实验不成功
set identity_insert dbo.Stutent on
insert into Stutent values('qqq',2)
set identity_insert dbo.Stutent off