如果每次刪除的都是最後一筆 dbcc checkident if object_id('T') is not null drop table T create table T(ID int identity(1,1),Name varchar(10)) insert T select 'A' insert T select 'B' insert T select 'C' delete T where id=3 dbcc checkident(T,reseed,2) insert T select 'C' select * from T ID Name ----------- ---------- 1 A 2 B 3 C(3 row(s) affected)
if object_id('T') is not null drop table T go create table T(ID int identity(1,1),Name varchar(10)) insert T select 'A' insert T select 'B' insert T select 'C' delete T where id=2 set identity_insert T on insert T(ID,Name) select 2,'B' set identity_insert T off insert T select 'E' select * from TID Name ----------- ---------- 1 A 2 B 3 C 4 E(4 row(s) affected)
if object_id('T') is not null
drop table T
create table T(ID int identity(1,1),Name varchar(10))
insert T select 'A'
insert T select 'B'
insert T select 'C'
delete T where id=3
dbcc checkident(T,reseed,2)
insert T select 'C'
select * from T
ID Name
----------- ----------
1 A
2 B
3 C(3 row(s) affected)
drop table T
go
create table T(ID int identity(1,1),Name varchar(10))
insert T select 'A'
insert T select 'B'
insert T select 'C'
delete T where id=2
set identity_insert T on
insert T(ID,Name) select 2,'B'
set identity_insert T off
insert T select 'E'
select * from TID Name
----------- ----------
1 A
2 B
3 C
4 E(4 row(s) affected)