将 iif 与 sql Servr 中的设置一起使用时，next near 不正确

capt 发表于 Dev

上尉

当我使用语句并在同一个查询中设置时，我们得到

'' 附近的语法不正确

    DECLARE @Enter int
    DECLARE @Month INT
    DECLARE @year INT 
    DECLARE @Delayed INT = NULL
    DECLARE @NextMonth INT =  null
    DECLARE @AfterNextMonth INT = NULL
    DECLARE @beyond INT = null


        SELECT @Enter = MONTH(GETDATE()), @year = YEAR(GETDATE())
        SELECT *
            SET @Delayed = IIF(MONTH(ExpectedDeliveryDate) <  MONTH(GETDATE()) AND YEAR(ExpectedDeliveryDate) < YEAR(GETDATE()), OpemAmount,'Null') 
            SET @Month = IIF(MONTH(ExpectedDeliveryDate) =  MONTH(GETDATE()), OpemAmount,'Null') 
            SET @NextMonth = IIF(MONTH(ExpectedDeliveryDate) =  MONTH(GETDATE()) + 1, OpemAmount,'Null')  
            SET @AfterNextMonth = IIF(MONTH(ExpectedDeliveryDate) =  MONTH(GETDATE()) +2, OpemAmount,'Null')  
            SET @beyond = IIF(MONTH(ExpectedDeliveryDate) >  MONTH(GETDATE()) AND YEAR(ExpectedDeliveryDate) > YEAR(GETDATE()) OR 
                             MONTH(ExpectedDeliveryDate) = Null , OpemAmount,'Null')  

            @Delayed AS Delayed, @Month AS '@Enter', @NextMonth AS '@NextMonth', @AfterNextMonth AS '@AfterNextMonth' , @beyond AS '@beyond'   
     FROM dbo.vwOpenSalesOrders

我们声明了 5 个变量，当我们在完成语句后在 @Delayed 中出现错误时会写什么。

上尉

SELECT *,
     IIF(MONTH(ExpectedDeliveryDate) <  MONTH(GETDATE()) AND YEAR(ExpectedDeliveryDate) < YEAR(GETDATE()), 'OpemAmount','Null') AS Delayed,
    IIF(MONTH(ExpectedDeliveryDate) =  MONTH(GETDATE()), 'OpemAmount','Null') AS Months,
   IIF(MONTH(ExpectedDeliveryDate) =  MONTH(GETDATE()) + 1,'OpemAmount','Null')  AS NextMonth,
    IIF(MONTH(ExpectedDeliveryDate) =  MONTH(GETDATE()) +2, 'OpemAmount','Null')  AS AfterNextMonth,
     IIF(MONTH(ExpectedDeliveryDate) >  MONTH(GETDATE()) AND YEAR(ExpectedDeliveryDate) >= YEAR(GETDATE()) OR 
                     MONTH(ExpectedDeliveryDate) = Null , 'OpemAmount','Null') AS  beyond

来自 dbo.vwOpenSalesOrders

本文收集自互联网，转载请注明来源。

如有侵权，请联系 [email protected] 删除。