----------------------------------去标识
alter table tablename add id1 intupdate tablename set id1=idalter table tablename drop column idexec sp_rename 'tablename.id1','id'或select cast (id as int) id,列..... into #temp from 表
drop table 表
select * into 表 from #temp
drop table #temp
alter table tablename add id1 intupdate tablename set id1=idalter table tablename drop column idexec sp_rename 'tablename.id1','id'或select cast (id as int) id,列..... into #temp from 表
drop table 表
select * into 表 from #temp
drop table #temp
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货