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

11 votes142 views1 answer
Sql query to find duplicates in column
SQL
0 vote181 views1 answer
Opensuse start MySQL
SQL
0 vote145 views1 answer
Create or replace view postgress
SQL
0 vote141 views1 answer
Change role postgres
SQL
0 vote133 views1 answer
Nth max in my sql
SQL
0 vote143 views1 answer
Prodection ready postgres database step by step
SQL
0 vote139 views1 answer
Table values functions in SQL
SQL
2 votes126 views2 answers
How to get capital letter first in sql
SQL
5 votes147 views2 answers
Oracle find all tables with column name
SQL
2 votes138 views2 answers
Sql query to list all tables in a database sql server
SQL