如果主键是自增的, set insert_identifier on 即可在自增列中插入值,如果想恢复以前的设置 set insert_identifier off
if object_id('tempdb..#T') is not null drop table #T go create table #T (ID int primary key) insert #T select 1 insert #T select 2 update #T set ID=3 where ID=1 select * from #TID ----------- 2 3(所影响的行数为 2 行)
set insert_identifier on
即可在自增列中插入值,如果想恢复以前的设置
set insert_identifier off
drop table #T
go
create table #T (ID int primary key)
insert #T select 1
insert #T select 2
update #T set ID=3 where ID=1
select * from #TID
-----------
2
3(所影响的行数为 2 行)