SQL 如何强行更新 Identity列

--创建测试表CREATE TABLE t1(ID int IDENTITY,A int)GO--插入记录INSERT t1 VALUES(1)GO--1. 将IDENTITY(标识)列变为普通列ALTER TABLE t1 ADD ID_temp intGOUPDATE t1 SET ID_temp=IDALTER TABLE t1 DROP COLUMN IDEXEC sp_rename N't1.ID_temp',N'ID',N'COLUMN'INSERT t1 VALUES(100,9)GO--2. 将普通列变为标识列CREATE TABLE t1_temp(ID int,A int IDENTITY)SET IDENTITY_INSERT t1_temp ONINSERT t1_temp(ID,A) SELECT * FROM t1SET IDENTITY_INSERT t1_temp OFFDROP TABLE T1GOEXEC sp_rename N't1_temp',N't1'INSERT t1 VALUES(109999)GO--显示处理结果SELECT * FROM t1/*--结果:ID          A ----------------- ----------- 1           1100         9109999      10--*/

点击打开链接