ALTER TABLE Strategy ADD ID_temp int
GO
UPDATE Strategy SET ID_temp=ID;
update Strategy set ID_temp=5 where ID=6;
update Strategy set ID_temp=6 where ID=5;
alter table strategy drop constraint PK_strategy;
ALTER TABLE Strategy DROP COLUMN ID;
EXEC sp_rename N'Strategy.ID_temp',N'ID',N'COLUMN';
ALTER TABLE Strategy ALTER COLUMN id int not null;
alter table Strategy add constraint PK_Strategy primary key (id);
ALTER TABLE Strategy alter column ID int IDENTITY(7,1); 这句不成功。先做个记录
GO
UPDATE Strategy SET ID_temp=ID;
update Strategy set ID_temp=5 where ID=6;
update Strategy set ID_temp=6 where ID=5;
alter table strategy drop constraint PK_strategy;
ALTER TABLE Strategy DROP COLUMN ID;
EXEC sp_rename N'Strategy.ID_temp',N'ID',N'COLUMN';
ALTER TABLE Strategy ALTER COLUMN id int not null;
alter table Strategy add constraint PK_Strategy primary key (id);
ALTER TABLE Strategy alter column ID int IDENTITY(7,1); 这句不成功。先做个记录