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

0 vote94 views1 answer
Edit a field mysql terminal
SQL
3 votes93 views1 answer
Set default today mysql
SQL
0 vote106 views1 answer
Mostrar datos de tablas relacionadas mysql kjava
SQL
-2 votes125 views1 answer
Mysql not empty
SQL
10 votes106 views1 answer
All_dependencies
SQL
4 votes105 views1 answer
Postgres delete last row
SQL
49 votes174 views6 answers
Get duplicate records in sql
SQL
15 votes108 views2 answers
Select where duplicate mysql
SQL
0 vote112 views1 answer
Oracle execute package dblink
SQL
1 vote95 views3 answers
Remove unique key from a table
SQL