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

2 votes185 views1 answer
Oracle list grants on procedure
SQL
7 votes179 views1 answer
Minecraft forge server host
SQL
0 vote184 views1 answer
Mysql backup certain tables workbench
SQL
1 vote212 views1 answer
Epoch time converter in snowflake
SQL
0 vote287 views1 answer
How to get all values in a table mysql in c#
SQL
-1 vote190 views2 answers
Postgresql get last 10 records
SQL
10 votes187 views3 answers
Sql check double value
SQL
8 votes173 views2 answers
Mysql query dates between two dates
SQL
3 votes190 views1 answer
Oracle revoke
SQL
0 vote285 views1 answer
Multiple replace value mssql
SQL