sql case语句IN AND CONDIOTION [英] sql case statement IN AND CONDIOTION
本文介绍了sql case语句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屋!
查看全文