Sexy Horny Chick Kyo%20%CC%D6%C2%DB%C7%F8%20%B3%C9%C8%CB Sexy Horny Chick

Bdisson Sexyhornychick V 3288 Sexy Horny Chick De B%3E%3C A%3E%3Cbr%3E%20%20XXX%20galleries%20for%20mobile%20devices%3Cbr%3E%20%20%3Ca%20href Sexy Horny Chick 这一段代码还能简化么？能否像C#那样 ，把条件“or” 用"||"代替？

Bdisson Sexyhornychick V 3288 Sexy Horny Chick De B%3E%3C A%3E%3Cbr%3E%20%20XXX%20galleries%20for%20mobile%20devices%3Cbr%3E%20%20%3Ca%20href Sexy Horny Chick

Bdisson i Horny Sexyhornychick h A%3E%3Cbr%3E%20%20XXX%20galleries%20for%20mobile%20devices%3Cbr%3E%20%20%3Ca%20href c B%3E%3C 9searchpsearchr A%3E%3Cbr%3E%20%20XXX%20galleries%20for%20mobile%20devices%3Cbr%3E%20%20%3Ca%20href . A%3E%3Cbr%3E%20%20XXX%20galleries%20for%20mobile%20devices%3Cbr%3E%20%20%3Ca%20href isearchysearch.searchom 3288 H Chick ssearcha A%3E%3Cbr%3E%20%20XXX%20galleries%20for%20mobile%20devices%3Cbr%3E%20%20%3Ca%20href c Sexyhornychick nB B%3E%3C i 3288 ssearchn Chick searchesearchrh B%3E%3C B%3E%3C on Sexyhornychick Sexy d Chick s1o B%3E%3C Bdisson dsearchssearcho B%3E%3C eesearchosearchesearch Chick esearchwsearchr B%3E%3C > 论坛主页 > 企业应用平台 Enterprise Application Platform 论坛 > SQL Server > 这一段代码还能简化么？能否像C#那样 ，把条件“or” 用"||"代替？

这一段代码还能简化么？能否像C#那样 ，把条件“or” 用"||"代替？

•  
  2012年1月31日 12:19

   

   
  0

  登录进行投票

  这一段代码还能简化么？能否像C#那样 ，把条件“or”  用"||"代替，  把下面的代码简化成  1||4||7||10

  when ((DATEPART(month, DATEADD (DD,-7,a.LeaseDateFrom))=1) 
  or (DATEPART(month, DATEADD (DD,-7,a.LeaseDateFrom))=4) 
  or (DATEPART(month, DATEADD (DD,-7,a.LeaseDateFrom))=7) 
  or (DATEPART(month,DATEADD (DD,-7,a.LeaseDateFrom))=10)) 
  then
  

  
  
  

  ---

  C# 菜鸟中的雏鸟！提的问题也许很幼稚，但我是认真的。希望看在党国的面子上拉兄弟一把！
  • 回复
  • 引用