存儲過程部分
USE [PaymentAnalysis]
GO/****** Object: StoredPRocedure [dbo].[Test] Script Date: 2017/2/10 14:18:35 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGO-- =============================================-- Author: <Author,,Name>-- Create date: <Create Date,,>-- Description: <Description,,>-- =============================================ALTER PROCEDURE [dbo].[Test](@Year nvarchar(10),@option nvarchar(Max),@All Decimal(18,2) output)ASBEGIN-- SET NOCOUNT ON added to prevent extra result sets from-- interfering with SELECT statements.SET NOCOUNT ON; Declare @sql nvarchar(MAX)set @sql = 'select @sum = sum(Convert(Decimal(18,2),'+@option+')) from dbo.StaticPM'+@Yearexec sp_executesql @sql,N'@sum Decimal(18,2) out',@All outselect @All as 函數內崗位工資和END
執行部分
--select sum(s.護理10占比) from (Declare @All Decimal(18,2)exec dbo.Test '2015','崗位工資',@All outputselect @All as 崗位工資和
新聞熱點
疑難解答
