嵌套存儲過程傳回值的調用

嵌套存儲過程傳回值的調用

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

create procedure sp_test1 

    declare @id int,@code varchar(8)

    exec sp_test2 @id out,@code out

    select @id as nid,@code as ncode

exec sp_test1

/*

nid         ncode    

----------- -------- 

1           aaaa

*/

drop procedure sp_test1,sp_test2

drop table test