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 vote261 views1 answer
Select odd records sql
SQL
0 vote259 views1 answer
Sql select max value for each group
SQL
1 vote258 views3 answers
Showing all columns in an sqlite table
SQL
0 vote269 views2 answers
Script all indexes in a database
SQL
0 vote254 views1 answer
Mysql Digital Ocean connection problems
SQL
0 vote270 views1 answer
Mysql join table with a text columns with ids splited by char
SQL
2 votes256 views1 answer
Postgresql transaction
SQL
0 vote200 views2 answers
Illuminate\Database\QueryExceptionSQLSTATE[HY000] [2002] No such file or directory
SQL
5 votes241 views1 answer
Sql first day of current year
SQL
58 votes508 views6 answers
Create new user in postgres
SQL