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

1 vote196 views3 answers
Sql select only time from datetime
SQL
53 votes348 views6 answers
How to install mysql ubuntu
SQL
0 vote190 views1 answer
Mysql query single row
SQL
2 votes175 views5 answers
Alter table primary key postgresql
SQL
0 vote188 views1 answer
Psql use query result convert Decimal python numpy psycopg2
SQL
-1 vote187 views2 answers
On update cascade
SQL
0 vote150 views1 answer
Sql table to store status
SQL
0 vote190 views1 answer
Create a PostgreSQL user django on mac
SQL
0 vote194 views1 answer
Mysql update even / odd rows
SQL
0 vote189 views1 answer
Changer un mot de passe mysql
SQL