1金币
select * from [SP_PersonWorkProgress_NoSta1] where 1=1 {IIF(@StartDate = null, "", "AND WorkOnDate>=@StartDate 00:00:00”)} {IIF(@EndDate = null, "", "AND WorkOnDate<=@EndDate 23:59:59”)}
@StartDate，@EndDate这两个是日期型，为什么上面加了 00:00:00和 23:59:59报错，应该怎么加
|
|
