UPDATE 表 SET 字段1 = (CASE WHEN 字段2 IS NULL THEN Fdate ELSE 字段 3 end)
例如:
UPDATE TblRepayMent SET FRepayDate = (CASE WHEN FFromBillType IS NULL THEN Fdate ELSE FCheckDate end)
UPDATE 表 SET 字段1 = (CASE WHEN 字段2 IS NULL THEN Fdate ELSE 字段 3 end)
例如:
UPDATE TblRepayMent SET FRepayDate = (CASE WHEN FFromBillType IS NULL THEN Fdate ELSE FCheckDate end)