34,594
社区成员
发帖
与我相关
我的任务
分享
DBCC CHECKIDENT
-- 例如,以下命令不重置而只是显示当前的Identity ID值
DBCC CHECKIDENT ('TableName', NORESEED);
CREATE TABLE [dbo].[Table1] (
[myid] [int] IDENTITY (1, 1) NOT NULL ,
[mytext] [char] (10)
)
--插入数据
insert into table1 (mytext) values('a111')
insert into table1 (mytext) values('a222')
insert into table1 (mytext) values('a333')
insert into table1 (mytext) values('a444')
insert into table1 (mytext) values('a555')
--查询并看结果
select * from table1
/*
myid mytext
----------- ----------
1 a1
2 a222
3 a333
4 a444
5 a555
(所影响的行数为 5 行)
*/
--去除自增
set identity_insert table1 on
insert into table1 (myid,mytext) values(100,'a111')
insert into table1 (myid,mytext) values(110,'a222')
--查询并看结果
select * from table1
/*
myid mytext
----------- ----------
1 a111
2 a222
3 a333
4 a444
5 a555
100 a111
110 a222
(所影响的行数为 7 行)
*/
--再次设置为自增
set identity_insert table1 off
--插入数据
insert into table1 (mytext) values('a111')
insert into table1 (mytext) values('a222')
insert into table1 (mytext) values('a333')
insert into table1 (mytext) values('a444')
insert into table1 (mytext) values('a555')
--查询并看结果
select * from table1
/*
myid mytext
----------- ----------
1 a111
2 a222
3 a333
4 a444
5 a555
100 a111
110 a222
111 a111
112 a222
113 a333
114 a444
115 a555
(所影响的行数为 12 行)
*/