本帖最后由 CainduranceTX 于 2023-7-11 11:22 编辑
.....我按照说明书讲的用如下句子:
select * from dbo.转诊登记表 where 1=1
{IIF(@起始值 = "", "", " and 转诊日期='" & @起始值 & "'")}
{IIF(@截止值 = "", "", " and 转诊日期='" & @截止值 & "'")}
{IIF(@统筹区 = "", "", " and 统筹区划='" & @统筹区 & "'")}
结果是只有第一行能生效,后边两行的条件无法生效~~~
|