/**************** 準(zhǔn)備環(huán)境********************/--判斷是否存在test表if object_id(N'test',N'U') is not nulldrop table test--創(chuàng)建test表create table test(id int not null,name varchar(20) not null)--插入臨時(shí)數(shù)據(jù)insert into test values (1,'成龍')insert into test values (3,'章子怡')insert into test values (4,'劉若英')insert into test values (8,'王菲')select * from test/**************** 實(shí)現(xiàn)更改自動(dòng)增長列********************/begin transactioncreate table test_tmp(id int not null identity(1,1),name varchar(20) not null)goset identity_insert test_tmp ongoif exists(select * from test)exec(' insert into test_tmp(id, name ) select id, name from test with(holdlock tablockx)')goset identity_insert test_tmp offgodrop table testgoexec sp_rename N'test_tmp' ,N'test' , 'OBJECT'gocommitGO/****************驗(yàn)證結(jié)果*****************/insert into test values ('張曼')select * from test