sql server where 中添加判断

 where 中都是boolean 类型，所以 if/else, case/when无法使用，select * from table1 where (1>0 and name='xxx') and (1>0 and name='yyy') and (1>0 or name='zzzz')

(1>0 and name='xxx' and name='yyyy') 等同于 if(1>0 and name='xxx') {name='yyyy'}.

注意and/or的区别哦。