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

9 votes269 views2 answers
Sql limit order by
SQL
0 vote270 views1 answer
Uncaught Error: Call to undefined function DatabaseOld\mysqli_connect()
SQL
34 votes330 views6 answers
Alter table add foreign key mysql
SQL
0 vote260 views1 answer
Mysql auto increment default value with prefix month and year
SQL
0 vote291 views1 answer
Sql change primary key to composite key
SQL
0 vote302 views1 answer
Delete a temporary table mysql
SQL
57 votes466 views5 answers
How to create a new user in postgresql
SQL
1 vote290 views1 answer
Round one decimal place mysql
SQL
1 vote285 views1 answer
Drop column if exists sql server
SQL
1 vote278 views2 answers
Insert sqlite
SQL