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

14 votes310 views3 answers
How to add default constraint in mysql
SQL
0 vote315 views1 answer
Pgadmin save data greyed out
SQL
9 votes308 views3 answers
Postgres make sql dump
SQL
3 votes283 views2 answers
Mysql config user password
SQL
0 vote262 views1 answer
MySQL FIND_IN_SET()
SQL
4 votes265 views1 answer
Oracle change nls_date_format permanently
SQL
10 votes279 views2 answers
Linux command line import mysql database
SQL
11 votes249 views1 answer
Reset identity sql server
SQL
9 votes296 views5 answers
Sql delete duplicate rows but keep one
SQL
0 vote270 views2 answers
Error while setting value 'ONLY_FULL_GROUP_BY,ALLOW_INVALID_DATES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' to 'sql_mode'
SQL