摘要: select count(*) from o_org where( case when ?='条件' and org_no='43101' then 1 when ?!='条件' then 1 else 0 end )=1两个条件相同 ,? 是参数的值 ,通过对?值的判断 动态添加条件org_no='43101'select * from o_org where( case when 1='1' and org_no='43101' then 1 when 1!='1' then 1 阅读全文
posted @ 2013-07-30 21:39 令狐冲之12 阅读(2829) 评论(0) 推荐(0) 编辑