要求 当满足一个条件或者多个条件时都能够查询出数据!
原有的SQL语句 select a.zyls1,a.zyls11,a.zyls2,a.zyls22,b.gsname,b.tel,a.title,a.id,a.adddate,b.lsr from wlw_jyzx_glyl as a left join wlw_user as b on a.username=b.username where a.title like '@title' and (a.zyls11=@zyls11 or a.zyls11 is null) and (a.zyls1=@zyls1 or a.zyls1 is null) and (a.zyls2=@zyls2 or a.zyls2 is null) and (a.zyls22=@zyls22 or a.zyls22 is null)
原有的SQL语句 select a.zyls1,a.zyls11,a.zyls2,a.zyls22,b.gsname,b.tel,a.title,a.id,a.adddate,b.lsr from wlw_jyzx_glyl as a left join wlw_user as b on a.username=b.username where a.title like '@title' and (a.zyls11=@zyls11 or a.zyls11 is null) and (a.zyls1=@zyls1 or a.zyls1 is null) and (a.zyls2=@zyls2 or a.zyls2 is null) and (a.zyls22=@zyls22 or a.zyls22 is null)
from wlw_jyzx_glyl as a left join wlw_user as b on a.username=b.username
where a.title like '@title'
and (a.zyls11=isnull(@zyls11,a.zyls11)
and (a.zyls1=isnull(@zyls1,a.zyls1)
and (a.zyls2=isnull(@zyls2,a.zyls2)
and (a.zyls22=isnull(@zyls22,a.zyls22)
from wlw_jyzx_glyl as a left join wlw_user as b on a.username=b.username
where a.title like '@title'
and isnull(a.zyls11,@zyls11)=@zyls11
and isnull(a.zyls12,@zyls11)=@zyls12
and isnull(a.zyls122,@zyls11)=@zyls122
a.title like '@title'
-->
a.title like '%'+@title+%''
select a.zyls1,a.zyls11,a.zyls2,a.zyls22,b.gsname,b.tel,a.title,a.id,a.adddate,b.lsr
from wlw_jyzx_glyl as a left join wlw_user as b on a.username=b.username
where a.title like '%'+@title+'%'
and a.zyls11=isnull(@zyls11,a.zyls11)
and a.zyls1=isnull(@zyls1,a.zyls1)
and a.zyls2=isnull(@zyls2,a.zyls2)
and a.zyls22=isnull(@zyls22,a.zyls22)
我们都不对~~null<>null
当变量传null时候查询所有
个人理解 不代表楼主观点
--如果变量不为null我这就是对的
select a.zyls1,a.zyls11,a.zyls2,a.zyls22,b.gsname,b.tel,a.title,a.id,a.adddate,b.lsr
from wlw_jyzx_glyl as a left join wlw_user as b on a.username=b.username
where a.title like '@title'
and isnull(a.zyls11,@zyls11)=@zyls11
and isnull(a.zyls12,@zyls11)=@zyls12
and isnull(a.zyls122,@zyls11)=@zyls122
FUCK 办公室的垃圾网络
然后重试下11#代码
isnull(a.zyls11,'')=isnull(@zyls11,isnull(a.zyls11,''))
谢谢提出
而且你这样的话''=null了