存储过程返回值

declare @sql nvarchar(4000);

declare @SumOperateFee money;

set @sql=' select * from orders where reservationtime > ''2009-7-22'''--简易的sql ，实际中复杂很多

set @sql='select @SumOperateFee=sum(a.pricedue) from ( '+@sql+' ) as a '

EXECUTE sp_executesql

@sql,

N'@SumOperateFee money output',

@SumOperateFee output;