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 vote183 views1 answer
Eliminar ultimo carcacter mysql
SQL
0 vote187 views1 answer
Oracle webcenter content search enginer
SQL
0 vote183 views1 answer
Create a view in sqlite
SQL
0 vote174 views1 answer
Oracle tablespace autoextend
SQL
13 votes183 views4 answers
Mysql select last 10 rows
SQL
0 vote180 views1 answer
How can I tell how many Cores SQL Server is actually using?
SQL
31 votes259 views4 answers
Mysql grant execute
SQL
1 vote182 views1 answer
Create another table from existing table sql oracle
SQL
0 vote138 views1 answer
How to get last client id sql
SQL
1 vote152 views1 answer
Unique vs distinct sql
SQL