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

2 votes209 views1 answer
Oracle run_duration average
SQL
-1 vote212 views1 answer
Ssql to lowercqse
SQL
5 votes221 views3 answers
DBMS_OUTPUT.PUT_LINE
SQL
0 vote205 views1 answer
Mysql filter based on datediff
SQL
0 vote226 views1 answer
Run sql script file and changes db name in this file using c#
SQL
0 vote222 views2 answers
Homebrew nysql launch
SQL
0 vote201 views1 answer
Date diff sql
SQL
0 vote225 views1 answer
Call object contructor and call methods of object
SQL
0 vote197 views3 answers
How to modify alter user root@localhost identified with mysql_native_password by properly
SQL
1 vote209 views1 answer
Insert column after column mysql
SQL