34,591
社区成员
发帖
与我相关
我的任务
分享
-- 表,必须删除重建,再通过 insert select 方式把数据导过来
create table test(id int identity(100,1) , name varchar(10))
go
insert into test(name) values('zhangsan1')
insert into test(name) values('zhangsan2')
insert into test(name) values('zhangsan3')
go
create table test_temp(id int identity(100,2) , name varchar(10))
go
set identity_insert test_temp on
insert into test_temp(id,name) select id , name from test
set identity_insert test_temp off
go
drop table test
go
sp_rename 'test_temp', 'test', 'object'
go
insert into test(name) values('lisi')
insert into test(name) values('wangwu')
go
select * from test
go
-- drop table test
go