删除行,会对自增列造成不连续。 在已经执行了插入操作但是又被事务回滚的操作,造成自增列的不连续 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 转载于:https://www.cnblogs.com/perfectdesign/archive/2008/01/30/identityinsert.html