假如有标识列,而且不生成新的标识值 SET IDENTITY_INSERT b on insert into b(field1,field2...) select (field1,field2...) from a where 条件 SET IDENTITY_INSERT b off delete from a where 条件
假如有标识列,而且不生成新的标识值 SET IDENTITY_INSERT b on insert into b(field1,field2...) select field1,field2... from a where 条件 SET IDENTITY_INSERT b off delete from a where 条件
insert into b select 字段名 from a where 条件 delete from a where 条件
SET IDENTITY_INSERT b on
insert into b(field1,field2...) select (field1,field2...) from a where 条件
SET IDENTITY_INSERT b off
delete from a where 条件
SET IDENTITY_INSERT b on
insert into b(field1,field2...) select field1,field2... from a where 条件
SET IDENTITY_INSERT b off
delete from a where 条件
select 字段名 from a
where 条件
delete from a where 条件