SQLServer_where添加类似ifelse条件(casewhen)

最新推荐文章于 2024-09-02 12:26:08 发布

icecoola_

最新推荐文章于 2024-09-02 12:26:08 发布

阅读量1.5w

点赞数 1

分类专栏： SqlServer 文章标签： sqlserver where条件查询 ifelse casewhen

本文链接：https://blog.csdn.net/icecoola_/article/details/86302565

版权

SqlServer 专栏收录该内容

36 篇文章 1 订阅

订阅专栏

java

		if (status!=null && !status.equals(""))
		{
			
			wheresql+="AND ISNULL(h.address, '') = 'hangzhou' ";
			if (status.equals("1")){//是
				wheresql+=" and y.is=1 ";
			}
			if (status.equals("0")){//否
				wheresql+=" and y.isActive=0 ";
			}
			if (status.equals("-1")){//空
				wheresql+=" and y.isActive is null AND y.newStatus in ( '3','5' ) ";
			}
		}

sqlserver

where 1=1 
and ( isnull('${status}','')=''
or
(
case when ISNULL(h.address, '') = 'hangzhou'  and c.isActive=1 then 1
when ISNULL(h.address, '') = 'hangzhou'  and c.isActive=0 then 0
when ISNULL(h.address, '') = 'hangzhou'  and c.isActive is null AND c.newStatus in ( '3','5' ) then -1
end  
)=isnull('${status}','')