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

2 votes239 views2 answers
Maximum execution time of 360 seconds exceeded
SQL
0 vote213 views1 answer
Mysql select distinct date from timestamp
SQL
5 votes230 views1 answer
JBDC
SQL
-1 vote201 views10 answers
Delete Query in SQL Server
SQL
0 vote216 views1 answer
Ffeathers express mysql application users login
SQL
0 vote210 views1 answer
Wordpress sql find and replace
SQL
1 vote235 views1 answer
Oracle enable job
SQL
0 vote255 views1 answer
Amount of entries in a table psql
SQL
1 vote234 views1 answer
Sql insert for each distinct value
SQL
21 votes229 views4 answers
Oracle add column
SQL