create proc testReturnValue(@age int,@tt varchar(10) Output)
as
if @age%2=0
begin
return
set @tt= (@age%2)+1
end
else
begin
set @tt= @age+1
end
return @tt
declare @ttt varchar(10)
exec testReturnValue 6,@ttt output
select @ttt
关键是 exec 的时候后面的参数要加上 output