DB/MSSQL

CASE 문

풍풍 2014. 1. 14. 17:43
UPDATE table_name 
SET col1=CASE ? 
    WHEN '' THEN col1 
    ELSE ? 
END 
WHERE col2=? and col3=?