5金币
最佳答案我看您现在的sql是这个:
SELECT w.ORDERDATE,w.ORDERFORMNO FROM orderform w
where 1=1
{IIF(@报表参数1 = "", "", "w.ORDERFORMNO= '" + @报表参数1 + "'")}
是不是应该给后面的条件加一个and
SELECT w.ORDERDATE,w.ORDERFORMNO FROM orderform w
where 1=1
{IIF(@报表参数1 = "", "", "and w.ORDERFORMNO= '" + @报表参数1 + "'")}
两个条件并列的时候加and并列呢
| |
| |
| |
| |
| |
| |
| |
| |