Answers for "sql if statement update"

sql update with statement

UPDATE mytable t		-- Update using WITH statement
SET value3 = (
    WITH comp AS (
        SELECT id, value1
        FROM mytable t
        WHERE value2 > 10
    )
    SELECT c.value1
    FROM comp c
    WHERE c.id = t.id
);

if update sql

-- SQL Server (update my_table after update on my_table)
CREATE TRIGGER trTest ON my_table AFTER UPDATE AS
IF UPDATE (col_name)	-- Optional, for particular column
BEGIN
    UPDATE my_table SET my_col_date = getdate() FROM my_table 
END
-- Oracle (insert into log table after update on my_table)
CREATE OR REPLACE TRIGGER trTest AFTER UPDATE ON my_table
FOR EACH ROW
BEGIN
    INSERT INTO my_log_table (LOG_DATE, ACTION) VALUES (SYSDATE, 'Changed');
END;