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 vote319 views1 answer
For select oracle
SQL
2 votes289 views1 answer
Sql missing records from another table
SQL
2 votes290 views1 answer
How to find constraints on a table in oracle
SQL
2 votes310 views3 answers
Sqlite3.OperationalError: near "7": syntax error
SQL
4 votes292 views1 answer
Datepart postgres
SQL
0 vote315 views2 answers
Port 5432 is already in use mac
SQL
2 votes283 views1 answer
How to check grants on a package in oracle
SQL
0 vote279 views4 answers
Database stuck at restoring state
SQL
15 votes297 views5 answers
If null mysql
SQL
-1 vote304 views1 answer
Default username and password for oracle 11g
SQL