create proc pr_b 
@a int,@b int
as
begin
select @a as a @b as b 
union all 
select @a+1 as a @b+1 as b 
end
go
 
-----创建存储过程pr_a,并调用存储过程pr_b的返回结果
create proc pr_a 
as
begin
create table #t (a int,b int) 
insert into #t (a,b)
exec pr_b 120,188
 
select * from #t
truncate table #t
drop table #t
end
go