if object_id('tb')is not null
drop table tb
go
create table tb
(
id int identity(1,1),
col1 varchar(10)
)
go
insert into tb values ('aa')
insert into tb values ('bb')
select * from tb
/*
id col1
----------- ----------
1 aa
2 bb
(2 行受影响)
*/
set identity_insert tb on
insert into tb (id,col1) values (10,'cc')
set identity_insert tb off
select * from tb
/*
id col1
----------- ----------
1 aa
2 bb
10 ff
(3 行受影响)
*/
insert into tb values ('dd')
select * from tb
/*
id col1
----------- ----------
1 aa
2 bb
10 cc
11 dd
(4 行受影响)
*/
set identity_insert tb on
insert into tb values (15,'ee')
/*
消息 8101,级别 16,状态 1,第 1 行
仅当使用了列列表并且 IDENTITY_INSERT 为 ON 时,才能为表'tb'中的标识列指定显式值。
*/
set identity_insert tb off
select * from tb
/*
id col1
----------- ----------
1 aa
2 bb
10 cc
11 dd
(4 行受影响)
*/