...和 [英] SQL CASE WHEN ...AND

问题描述

有没有办法编写这样的SQL查询:

Is there a way to write a SQL query like this:

CASE WHEN DATEPART(yy,@year_end) = 2013 AND DATEPART(mm,@year_end) = 3         
        THEN @AdjStartYear = '2012/07/01' AND @AdjEndYear = '2012/12/31'

基本上，我希望在评估CASE语句后发生两件事.

Basically, I want 2 things to happen after the CASE statement is evaluated.

谢谢

推荐答案

否，您必须发表2个案例陈述

No, you have to make 2 case statements

select @AdjStartYear = CASE WHEN DATEPART(yy,@year_end) = 2013 AND DATEPART(mm,@year_end) = 3
                            THEN  '2012/07/01' 
                       END,
       @AdjEndYear = CASE WHEN DATEPART(yy,@year_end) = 2013 AND DATEPART(mm,@year_end) = 3
                          THEN  '2012/12/31' 
                     END

这篇关于...和的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！