22,207
社区成员
发帖
与我相关
我的任务
分享
select * from tb where 1=1 and fieldX = isnull(@fieldX,fieldX) and fieldY=isnull(@fieldY,fieldY)
charindex(',' + rtrim(v.business_category) + ',' , ',' + @paraBusinessCategory + ',') > 0 --like的写法不写了.一新的,注意加前后辍','就可以了.
charindex(',' + rtrim(v.business_category) + ',' , ',' + isnull(@paraBusinessCategory,rtrim(v.business_category)) + ',') > 0
select * from tb where 1=1 and fieldX = isnull(NULLIF(@fieldX,''),fieldX) and fieldY=isnull(NULLIF(@fieldY,''),fieldY)