ALTER TABLE 表 ADD 编号1 bigint identity(1,1) not null
go
SET IDENTITY_INSERT 表 ON
go
update 表 set 编号1=编号
go
SET IDENTITY_INSERT 表 OFF
go
ALTER TABLE 表 DROP COLUMN 编号
go
exec sp_rename '表.编号1','编号'
go
SET IDENTITY_INSERT 表 ON
go
update 表 set 编号1=编号
go
SET IDENTITY_INSERT 表 OFF
go
ALTER TABLE 表 DROP COLUMN 编号
go
exec sp_rename '表.编号1','编号'
go
SET IDENTITY_INSERT cruise ON
go
update cruise set cruise_cd1=cruise_cd
go
SET IDENTITY_INSERT cruise OFF
go
ALTER TABLE cruise DROP COLUMN cruise_cd
go
exec sp_rename 'cruise.cruise_cd1','cruise_cd'
go
add cruise_cd int identity(1,1)