Answers for "sql trigger after insert"

SQL
8

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;
Posted by: Guest on July-10-2021
1

mssql trigger examples

CREATE TRIGGER trigger_name   
ON { Table name or view name }   
[ WITH <Options> ]  
{ FOR | AFTER | INSTEAD OF }   
{ [INSERT], [UPDATE] , [DELETE] }
Posted by: Guest on July-16-2020
0

trigger before insert sql code

CREATE TRIGGER trigger_name
    BEFORE INSERT
    ON table_name FOR EACH ROW
trigger_body;
Posted by: Guest on May-22-2020
0

trigger before insert sql code

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 ;
Posted by: Guest on May-22-2020

Code answers related to "sql trigger after insert"

Code answers related to "SQL"

Browse Popular Code Answers by Language