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 vote340 views1 answer
Go install mysql
SQL
0 vote374 views1 answer
How to update date value in sql
SQL
0 vote354 views1 answer
How to create a new shema using query languaage
SQL
0 vote410 views2 answers
Pl sql auto increment
SQL
7 votes371 views5 answers
Show details of table postgres
SQL
1 vote352 views1 answer
How refresh navicat tables to see new tables
SQL
0 vote347 views2 answers
Sql if empty then
SQL
0 vote381 views1 answer
How to remove quotes from a string in ssis load file
SQL
12 votes354 views1 answer
Script to add new column in table sql
SQL
1 vote378 views1 answer
Sql check roles
SQL