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

8 votes304 views1 answer
Mysql restore database
SQL
0 vote345 views1 answer
Mysql error 1114 (hy000) the table is full
SQL
0 vote329 views2 answers
Import .sql into postgres db command
SQL
0 vote411 views1 answer
InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
SQL
1 vote315 views1 answer
Oracle duration between timestamps
SQL
0 vote323 views1 answer
TSQL convert csv to table
SQL
0 vote270 views1 answer
'0000-00-00' for column '
SQL
0 vote330 views1 answer
Oracle running queries
SQL
0 vote319 views4 answers
Forenkey code alchemy sql
SQL
1 vote339 views1 answer
Base64 encode sql server
SQL