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 vote156 views3 answers
How to modify alter user root@localhost identified with mysql_native_password by properly
SQL
0 vote186 views2 answers
Check if sql temp table exists
SQL
2 votes156 views2 answers
Insert all in sql
SQL
0 vote149 views1 answer
How to add more columns to a table in mysql
SQL
0 vote160 views1 answer
Query archive mode
SQL
0 vote180 views1 answer
Error Code: 1267. Illegal mix of collations (latin1_general_ci,IMPLICIT) and (latin1_swedish_ci,IMPLICIT) for operation '=' 0.000 sec
SQL
0 vote153 views1 answer
What is between keyword used for
SQL
0 vote155 views1 answer
Sql values that contains certain multiple ids
SQL
1 vote1.9K views1 answer
Dropping a constraint in ms sql
SQL
0 vote149 views1 answer
Get server date mysql
SQL