嵌套存储过程返回值的调用

create table test(id int identity(1,1),code varchar(8))
insert into test select 'aaaa' union select 'bbbb'
go

create procedure sp_test2
@id   int        output,
@code varchar(8) output
as
begin
    select @id=id,@code=code from test where code='aaaa'
    return
end
go

create procedure sp_test1
as
begin
    declare @id int,@code varchar(8)
    exec sp_test2 @id out,@code out
    select @id as nid,@code as ncode
end
go