sql case语句IN AND CONDIOTION [英] sql case statement IN AND CONDIOTION

问题描述

美好的一天所有我选择查询的地方和条件声明的条件陈述我不能让案件陈述正常工作请帮助我



< pre lang =sql> AND Sa.AllocatedDate =
CASE WHEN @ Allocated = ' not Allatedated THEN NULL
CASE WHEN @ Allocated = ' 已分配' THEN IS NOT null
END

解决方案

删除<$ c来自quer的$ c> IS y。

检查这个在静态SQL中实现动态WHERE子句 - 使用CASE [ ^ ]

试试这个...

  AND  ISNULL（DATALENGTH（Sa.AllocatedDate）， 0 ）= 
  CASE   WHEN  @ Allocated = ' 未分配' 那么  0  
  ELSE   8   END  

快乐编码！

：）

Good day all I have select query with a where and a and condition with a case statement I cannot get the case statement to work correctly please help me

AND Sa.AllocatedDate =
            CASE WHEN @Allocated='not Allocated' THEN NULL
            CASE WHEN @Allocated='Allocated' THEN IS NOT null
            END

解决方案

Remove IS from query.

Check this Implementing Dynamic WHERE-Clause in Static SQL - Using CASE[^]

try this...

AND ISNULL(DATALENGTH(Sa.AllocatedDate),0) =
            CASE WHEN @Allocated='not Allocated' THEN 0
            ELSE 8 END

Happy Coding!
:)

这篇关于sql case语句IN AND CONDIOTION的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！