Create Proc AAA
@a int
as
exec('create table aa
(a varchar(100),b varchar(100))')
insert into aa
values( @a,@a)
@a int
as
exec('create table aa
(a varchar(100),b varchar(100))')
insert into aa
values( @a,@a)
@a int
as
exec('create table aa
(a varchar(100),b varchar(100))')
insert into aa
values( @a,@a)
drop table aa
Declare kk cursor for
select a from B
open kk
fetch next from kk into @a
while @@fetch_status=0
begin
exec AAA @a ----動態給AAA
fetch next from kk into @a
end
close kk
deallocate kk
--
1
2
3
4
-----
现在我想把表B的动态循环的附加给AAA(存储过程) @a
把存储过程生成的表插去另一个表,
create table aa
(a varchar(100),b varchar(100))我的意思是
insert into aa
AAA 1
union
insert into aa
AAA 2
union
AAA 3
.....
其中AAA后面的数据是从B中来的