存储过程中调用存储过程的问题

[zyb51]

CREATE Procedure a
as
begin
SELECT top 1 id,name from users
end
GO

我在另一个存储过程中怎么得到这a返回的id,与name呢？？

[-狙击手-]

create proc b
as
begin
declare @t table(id int,name varchar(20))
insert @t exec a
...

end

[chuifengde]

create proc a 
    @id int output,
    @name varchar(20) output
as
    select top 1 @id=id,@name=name from [users]


create proc b
as
   declare @idB int,@nameB varchar(20)
   exec a @idB out,@nameB out
   select @idB,@nameB

[kk19840210]

alter   Procedure   a  
@id int output,@name int output
as 
begin 
SELECT   top   1   @id=id,@name=name   from   users 
end 

create proc test
as
begin
	declare @id varchar(10),@name varchar(10)
	exec a @i output ,@name output --得到 id ,name
	select @i
	select @sum
end

[zyb51]

谢谢

[daviszr_1979]

Create Table aa(id int, name nvarchar(20))


Insert aa(id,name) select 1,'张三'


Create PROCEDURE B 
As 
Declare @id int, 
@Name nvarchar(20)
   Set @id = 0
   Set @Name = ''	
   Exec A @id,@Name
   print @id
   Print @Name
   	

Create Proc A
  @id int Output,
  @Name nvarchar(20) Output 
as
  Select @id=id, @Name=Name From aa