用户z6964992(提问者) 回复 Z4u3z1select* from dbo.Consolidate
where 1=1
${if(len(BU)==0,\"\",\"and BU in( \'\"+Bu+\"\')\")}
${if(len(Province)==0,\"\",\"and Province in( \'\"+Province+\"\')\")}
${if(len(Region )==0,\"\",\"and Region in( \'\"+Region +\"\')\")}
用户z6964992(提问者)select* from dbo.Consolidate
where 1=1
${if(len(BU)==0,\"\",\"and BU in( \'\"+Bu+\"\')\")}
${if(len(Province)==0,\"\",\"and Province in( \'\"+Province+\"\')\")}
${if(len(Region )==0,\"\",\"and Region in( \'\"+Region +\"\')\")}