CREATE PROCEDURE test
(@subject Varchar(15) Output)
AS
select @subject='dgdsgf'
GO

DECLARE @aa Varchar(10)
execute test @aa output
select aa=@aa

参考一下上面的