日期:2014-05-16 浏览次数:20429 次
UPDATE cdssa SET cnno = CASE WHEN (cnno IS NULL OR TRIM(cnno)='') THEN '${CNNO}' else cnno end, stdt = CASE WHEN (stdt IS NULL OR TRIM(stdt)='') THEN '${STDT}' else stdt end, eddt = CASE WHEN (eddt IS NULL OR TRIM(eddt)='') THEN '${EDDT}' else eddt end WHERE cuno = '${CUNO}';?