T-SQL Create Trigger

CREATE TRIGGER production.trg_product_audit
ON production.products
AFTER INSERT, DELETE
AS
BEGIN
    SET NOCOUNT ON;
    INSERT INTO production.product_audits(
        product_id, 
        product_name,
        brand_id,
        category_id,
        model_year,
        list_price, 
        updated_at, 
        operation
    )
    SELECT
        i.product_id,
        product_name,
        brand_id,
        category_id,
        model_year,
        i.list_price,
        GETDATE(),
        'INS'
    FROM
        inserted i
    UNION ALL
    SELECT
        d.product_id,
        product_name,
        brand_id,
        category_id,
        model_year,
        d.list_price,
        GETDATE(),
        'DEL'
    FROM
        deleted d;
END
Code language: SQL (Structured Query Language) (sql)

Source: sqlservertutorial.net

Similar codes

1 vote114 views1 answer
Oracle lock user
SQL
0 vote115 views2 answers
CREATE TABLE researcher ( researcherid serial PRIMARY KEY, name text );
SQL
-1 vote136 views1 answer
Phinehas Psalm 106
SQL
0 vote123 views1 answer
Tsql cmd exec script from file
SQL
0 vote135 views1 answer
Postgresql auto increment not working
SQL
1 vote122 views1 answer
Oracle avg
SQL
0 vote132 views1 answer
Get the previous column of a table in mysql
SQL
3 votes120 views1 answer
Uppercase and lowercase in sql
SQL
1 vote119 views1 answer
Oracle add proxy
SQL
0 vote128 views1 answer
(PDOException(code: 2002): SQLSTATE[HY000] [2002] Permission denied at
SQL