嵌套預存程序傳回值的調用

嵌套預存程序傳回值的調用

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

exec sp_test1
go
/*
nid         ncode    
----------- -------- 
1           aaaa
*/

drop procedure sp_test1,sp_test2
drop table test