CREATE PROCEDURE abc
@id int
As
select * into #a from cart where id=@idexec('
alter table #a add ordercode varchar(25) null
')update #a set ordercode='12345'
insert into cart2 select * from #a
GO
@id int
As
select * into #a from cart where id=@idexec('
alter table #a add ordercode varchar(25) null
')update #a set ordercode='12345'
insert into cart2 select * from #a
GO
alter table #a add ordercode varchar(25) null
update #a set ordercode='12345'
表字段修改语句和该字段修改语句必须存在于两个批处理中
alter table #a add ordercode varchar(25) null
go
update #a set ordercode='12345'
就可以了
CREATE PROCEDURE abc
@id int
As
select *,space(25) as ordercode into #a from cart where id=@id
--alter table #a add ordercode varchar(25) null
update #a set ordercode='12345'
insert into cart2 select * from #a
GO