sql - 如何手动插入身份？

Question

CREATE TABLE masterTbl (
id INT IDENTITY(1,1) CONSTRAINT pk_id PRIMARY KEY,
name VARCHAR(100))

INSERT INTO masterTbl VALUES ('ABC', 'XYZ','PQR')

现在

Select * FROM masterTbl

结果:

id  | name
---------------------
1 |  ABC
2 |  XYZ
3 |  PQR

DELETE FROM masterTbl WHERE id=1

现在

Select * FROM masterTbl

结果:

id |  name
---------------------
2 |  XYZ
3 |  PQR

现在我想运行:

INSERT INTO masterTbl (id, name) VALUES (1, 'MNO')

这怎么可能？

Answer 1

在最简单的形式中，您需要暂时允许插入身份值

SET IDENTITY_INSERT masterTbl ON
INSERT INTO masterTbl (id, name) VALUES (1, 'MNO')
SET IDENTITY_INSERT masterTbl OFF