ISNULL(數字欄位1 * 0, 1) + ISNULL(數字欄位2 * 0, 1) + ISNULL(數字欄位3 * 0, 1) --or ISNULL...
可以試試 where ((startdate == null || enddate == null) || (x.ARRIVE_DATE == startdat...