2种造成sqlserver自增列不连续的原因
删除行,会对自增列造成不连续。
在已经执行了插入操作但是又被事务回滚的操作,造成自增列的不连续
在已经执行了插入操作但是又被事务回滚的操作,造成自增列的不连续
create table aaa
(
id int identity not null,
[name] char(3) not null
)
begin tran
select * from aaa
insert into aaa values ('as')
select * from aaa
rollback tran
select * from aaa
insert into aaa values ('asw')
select * from aaa
(
id int identity not null,
[name] char(3) not null
)
begin tran
select * from aaa
insert into aaa values ('as')
select * from aaa
rollback tran
select * from aaa
insert into aaa values ('asw')
select * from aaa