應該不行!不過這种情況是可以的
create proc sp_A
AS
select top 10 itno , itdesc from TabA
select top 10 itno , itdesc from TabBgocreate proc sp_B
AS
create table # (itno varchar(30) , itdesc varchar(30) )
insert into # exec sp_A
select * from # ---這里會得到 20條記錄
create proc sp_A
AS
select top 10 itno , itdesc from TabA
select top 10 itno , itdesc from TabBgocreate proc sp_B
AS
create table # (itno varchar(30) , itdesc varchar(30) )
insert into # exec sp_A
select * from # ---這里會得到 20條記錄
如果两个结果集的结构不一样,也可以吗?有示例不?
create proc a1
as
select price,quantity from table1 order by quantity compute sum(quantity),avg(price) 执行该过程,显示两个结果集
exec a1