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 vote167 views3 answers
Postgres date difference seconds
SQL
0 vote214 views1 answer
Osm2pgsql mac
SQL
0 vote170 views1 answer
Take sql dump in to file
SQL
0 vote158 views1 answer
Ansi sql count duplicate rows
SQL
4 votes156 views1 answer
Restart for pg_hba.conf file
SQL
1 vote173 views2 answers
Mysql extract number from string
SQL
12 votes167 views5 answers
Sql primary key
SQL
3 votes190 views3 answers
Cannot truncate a table referenced in a foreign key constraint
SQL
7 votes161 views1 answer
Query postgres delete duplicates
SQL
0 vote162 views1 answer
A good way of running a SQL query in JDBC using a parameterized statement
SQL