SAP HANA SQL CREATE TRIGGER

举例说明

CREATE TRIGGER TEST_TRIGGER_VAR_UPDATE                   
AFTER UPDATE ON TARGET                                   
REFERENCING NEW ROW mynewrow, OLD ROW myoldrow          
FOR EACH ROW                                             
BEGIN                                                    INSERT INTO SAMPLE_new VALUES(:mynewrow.a, :mynewrow.b); INSERT INTO SAMPLE_old VALUES(:myoldrow.a, :myoldrow.b);INSERT INTO SAMPLE VALUES(0, 'trigger');
END;