DECLARE @SQLString nvarchar(3000) ,
@ParamDefinition nvarchar(500) ,
@Amount MONEY ,
@Count INT
SET @SQLString = 'SELECT @inner_amount= SUM(amount),@innerCount=count(*) FROM v_account_cancel_list WHERE'+'[status] in(''Ready'',''Success'') '
SET @ParamDefinition = N'@inner_amount int OUTPUT,@innerCount int output';
EXECUTE sp_executesql @SQLString ,
@ParamDefinition ,
@inner_amount = @Amount OUTPUT ,
@innerCount=@Count OUTPUT
SELECT @Amount
SELECT @Count
如何输出动态sql 中的结果
最新推荐文章于 2024-08-22 02:09:51 发布