SAP HANA SQL CREATE TRIGGER

xiaoxiao2021-02-28  108

举例说明

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;

转载请注明原文地址: https://www.6miu.com/read-64846.html

最新回复(0)