--测试资料 CREATE TABLE t1(ID int IDENTITY,A int)INSERT t1 VALUES(1)INSERT t1 VALUES(2)INSERT t1 VALUES(3)DELETE FROM t1 WHERE A=2GO --将ID=3的记录的ID值改为2SET IDENTITY_INSERT t1 ONINSERT t1(ID,A) SELECT 2,A FROM t1 WHERE ID=3DELETE FROM t1 WHERE ID=3SET IDENTITY_INSERT t1 OFFSELECT * FROM t1/*--结果ID A ----------------- ----------- 1 12 3--*/
除非truncate表内容后重插入.
CREATE TABLE t1(ID int IDENTITY,A int)INSERT t1 VALUES(1)INSERT t1 VALUES(2)INSERT t1 VALUES(3)DELETE FROM t1 WHERE A=2GO --将ID=3的记录的ID值改为2SET IDENTITY_INSERT t1 ONINSERT t1(ID,A) SELECT 2,A FROM t1 WHERE ID=3DELETE FROM t1 WHERE ID=3SET IDENTITY_INSERT t1 OFFSELECT * FROM t1/*--结果ID A ----------------- ----------- 1 12 3--*/