先
select * into temptable from tablename
go
truncate table tablename
go在设置表改u_id字段为标识字段。再
SET IDENTITY_INSERT databasename..tablename ON
go
insert tavlename
select * into temptable
go
SET IDENTITY_INSERT databasename..tablename Off
go
select * into temptable from tablename
go
truncate table tablename
go在设置表改u_id字段为标识字段。再
SET IDENTITY_INSERT databasename..tablename ON
go
insert tavlename
select * into temptable
go
SET IDENTITY_INSERT databasename..tablename Off
go
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货