procedure 存储过程多个返回测试

create procedure test(@temp1 varchar(10) output,@temp2 varchar(10) output,@temp3 varchar(10) output,@temp4 varchar(10) output)
as
begin
set @temp1 = 'a';
set @temp2 = 'b';
set @temp3 = 'c';
set @temp4 = 'd' ;
end

declare @temp1 varchar(10) ,@temp2 varchar(10) ,@temp3 varchar(10) ,@temp4 varchar(10)
execute test @temp1 output,@temp2 output,@temp3 output,@temp4 output
select @temp1,@temp2,@temp3,@temp4