建一个简单的存储过程A,输出2个值: Create Proc A @AOUTPUT1 int output, @AOUTPUT2 int output As begin set @AOUTPUT1 = 100 set @AOUTPUT2 = 50 return end Go 建另一个存储过程B,在B里执行A,并获得A的2个结果值: Create Proc B As begin DECLARE @i as int DECLARE @i2 as int exec A @i output,@i2 output print @i print @i2 return end Go exec B 执行的结果,输出100,50 :)