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 votes326 views3 answers
Sequence postgresql
SQL
0 vote336 views1 answer
Minus equivalent in my sql
SQL
1 vote360 views1 answer
Update substring in mysql
SQL
1 vote317 views3 answers
String to int mysql
SQL
0 vote328 views1 answer
What is the use of index in mysql table
SQL
1 vote355 views1 answer
Psql human readable
SQL
0 vote332 views1 answer
Sql query to get column names and data types in sql server
SQL
0 vote370 views1 answer
Dual in db2
SQL
8 votes357 views1 answer
Sql remove leading spaces
SQL
4 votes352 views2 answers
Tsql utf to local time
SQL