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

4 votes348 views1 answer
Oracle table statistics last analyzed
SQL
1 vote334 views1 answer
Mysql2::Error: Incorrect string value: '\xE2\x80\x8B
SQL
1 vote377 views1 answer
How to ckeck that email is present in databse in mysqli
SQL
0 vote395 views1 answer
Sqlcl format
SQL
0 vote351 views1 answer
Sql get month and year from date
SQL
0 vote345 views1 answer
Change schema of all tables postgres
SQL
10 votes353 views4 answers
Mysql one week ago
SQL
1 vote343 views1 answer
How to truncate a table in databse
SQL
0 vote364 views1 answer
How to get data from 2 database
SQL
20 votes369 views5 answers
Reset auto increment mysql
SQL