在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的代码做了什么改动,一般来说重启是不应该影响自增值的