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 vote357 views1 answer
Oracle db timestamp auto add
SQL
1 vote264 views1 answer
Mysql change root mysql_native_password
SQL
7 votes258 views1 answer
Postgres base size
SQL
0 vote250 views1 answer
Redirection 301 htaccess nom de domaine
SQL
1 vote448 views3 answers
Sql subquery
SQL
0 vote269 views1 answer
Avoid duplicate in one to many relationship join in sql
SQL
0 vote266 views1 answer
Mysql count unique in group statement
SQL
5 votes267 views1 answer
Sqlite alter table add column
SQL
0 vote294 views2 answers
SQLSTATE[HY000]: General error: 3780 Referencing column 'role_id' and referenced column 'id' in foreign key constraint 'user_role_id foreign' are incompatible.
SQL
0 vote255 views1 answer
Mysql jdbc timezone
SQL