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 vote202 views1 answer
Postgress append string in select
SQL
0 vote185 views1 answer
Psql select * from table
SQL
0 vote198 views1 answer
Sauvegarde complète my sql
SQL
5 votes189 views2 answers
Sql number columns
SQL
0 vote197 views1 answer
Laravel general error 2006 mysql server has gone away
SQL
7 votes214 views1 answer
Sql limit decimal places
SQL
0 vote201 views1 answer
Mysql a from on this page has
SQL
-1 vote200 views1 answer
Su: Authentication failure mysql
SQL
0 vote203 views1 answer
Count columns psql(PostreSQL)
SQL
11 votes372 views4 answers
Round in sql
SQL