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

3 votes322 views3 answers
Remove all spaces from string sql
SQL
0 vote343 views3 answers
Drop table operation failed on table 'TableHistory' because it is not supported operation on system-versioned temporal tables.
SQL
0 vote339 views1 answer
Oracle remove line breaks
SQL
1 vote501 views1 answer
Postgres upgrade to superuser
SQL
0 vote354 views1 answer
Trigger vérifier stock
SQL
4 votes319 views1 answer
Force drop all tables postgres
SQL
1 vote333 views1 answer
Sql group by sum with condition
SQL
1 vote329 views1 answer
Sql alchemy with azuresql server
SQL
0 vote322 views1 answer
Sql clear table
SQL
6 votes322 views5 answers
Mysql get last insert id
SQL