sql新增自增id_SQL数据库中自增列值跳跃增长

在sql2008r2 开发版里测试没有LZ的情况

SQL2008R2

USE [sss]

CREATE TABLE testidentity(id INT IDENTITY(1,1) PRIMARY KEY,name VARCHAR(20))

INSERT INTO testidentity

SELECT '1' UNION ALL

SELECT '2' UNION ALL

SELECT '3'

SELECT * FROM testidentity

--重启sqlserver

INSERT INTO testidentity

SELECT '4' UNION ALL

SELECT '5' UNION ALL

SELECT '6'

SQL2012

USE [test]

CREATE TABLE testidentity(id INT IDENTITY(1,1) PRIMARY KEY,name VARCHAR(20))

INSERT INTO testidentity

SELECT '1' UNION ALL

SELECT '2' UNION ALL

SELECT '3'

SELECT * FROM testidentity

--重启sqlserver

INSERT INTO testidentity

SELECT '4' UNION ALL

SELECT '5' UNION ALL

SELECT '6'

SELECT * FROM testidentity

我测试过

sql2008r2

sql2012

不知道sql2012的代码做了什么改动，一般来说重启是不应该影响自增值的