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

5 votes347 views1 answer
Oracle ora-00054 find
SQL
0 vote323 views1 answer
Write SQL in ruby on rails
SQL
4 votes293 views2 answers
Postgresql default value
SQL
0 vote311 views1 answer
ERROR: column "hourly_visitors.hour" must appear in the GROUP BY clause or be used in an aggregate function
SQL
2 votes319 views1 answer
Q operator in plsql
SQL
16 votes296 views2 answers
Add column to all tables after first column mysql
SQL
0 vote289 views1 answer
How to stop all connections to a psql 12 database?
SQL
8 votes306 views3 answers
Alter user root mysql
SQL
0 vote277 views1 answer
Stop psql server windows
SQL
0 vote273 views1 answer
Selects all the columns from the sailors table
SQL