sql trigger after insert
-- SQL Server (update my_table2 after insert on my_table1)
CREATE TRIGGER trigger_name ON my_table1 FOR INSERT AS
BEGIN
UPDATE my_table2 SET my_col_date = getdate() FROM my_table1
END
-- Oracle (insert into log table after update on my_table)
CREATE OR REPLACE TRIGGER trigger_name AFTER INSERT ON my_table
FOR EACH ROW
BEGIN
INSERT INTO my_log_table (LOG_DATE, ACTION) VALUES (SYSDATE, 'Changed');
END;
4.89
9
DELIMITER $$
CREATE TRIGGER before_workcenters_insert
BEFORE INSERT
ON WorkCenters FOR EACH ROW
BEGIN
DECLARE rowcount INT;
SELECT COUNT(*)
INTO rowcount
FROM WorkCenterStats;
IF rowcount > 0 THEN
UPDATE WorkCenterStats
SET totalCapacity = totalCapacity + new.capacity;
ELSE
INSERT INTO WorkCenterStats(totalCapacity)
VALUES(new.capacity);
END IF;
END $$
DELIMITER ;
Thank you!
9
0
3.38
8
CREATE TRIGGER trigger_name
ON { Table name or view name }
[ WITH <Options> ]
{ FOR | AFTER | INSTEAD OF }
{ [INSERT], [UPDATE] , [DELETE] }
Thank you!
8
0
0
0
CREATE TRIGGER trigger_name
BEFORE INSERT
ON table_name FOR EACH ROW
trigger_body;
Thank you!
0
0
Are there any code examples left?
New code examples in category SQL