sql报表过滤不填写条件显示所有数据

AND 1 = CASE WHEN ISNULL(@FSALNO, '') = '' THEN 1
ELSE CASE WHEN ISNULL(t2.FBillNo, '') = @FSALNO
THEN 1
ELSE 0
END
END

原文地址:https://www.cnblogs.com/liangyuwen/p/12302835.html