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 vote142 views1 answer
With_for_update sqlalchemy
SQL
0 vote148 views1 answer
Sql dmv to capture updates
SQL
0 vote140 views1 answer
How to convert DateTime to VarChar SQL
SQL
2 votes149 views3 answers
Mysql pass command from command line
SQL
1 vote146 views1 answer
Altering the column name in MySQL to have a default value
SQL
0 vote139 views1 answer
Changer un mot de passe mysql
SQL
1 vote145 views4 answers
Fatal database postgres does not exist
SQL
0 vote169 views1 answer
Oracle current date minus 1 day
SQL
0 vote149 views1 answer
What is between keyword used for
SQL
2 votes163 views1 answer
Postgresql resolv duplicate value violates unique constraint
SQL