在已经执行了插入操作但是又被事务回滚的操作,造成自增列的不连续
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