create procedure proc1(@parm1 integer,@parm2 varchar(30) output)
as
select @parm2='zhongguo'
select * from table1 where age=@parm1
return 100
declare @param1 int ,@param2 varchar(30)
declare @tmpa int
set @param1=20
/****这一句为重点**/
execute @tmpa = proc1 @param1,@param2 output
print @tmpa
print @param2