[SQL]sql server中如何直接查询存储过程EXEC返回的结果集?

时间:2018-06-01 15:06:55   收藏:0   阅读:778
                Declare @T Table (iDay VARCHAR(4),iNum DECIMAL(18,2),yuxiang DECIMAL(18,9))
                Insert @T 

                --EXEC    [dbo].[BSP0101_GetYuXiang]
                --        @YearMonth = N201801,
                --        @Type = N工具费,
                --        @Department = N01010102,
                --        @EngineType = NZR

                EXEC    [dbo].[BSP0101_GetYuXiang]
                        @YearMonth = @vcYearMonth,
                        @Type = @FMName,
                        @Department = @LineCode,
                        @EngineType =@Engine

                DECLARE @RiBiesum DECIMAL(18,2)
                Select @RiBiesum=ROUND(SUM(yuxiang),2) from @T 
                PRINT @RiBiesum

 

原文:https://www.cnblogs.com/beeone/p/9121603.html

评论(0
© 2014 bubuko.com 版权所有 - 联系我们:wmxa8@hotmail.com
打开技术之扣,分享程序人生!