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

3 votes324 views1 answer
Difference sql vs mysql
SQL
8 votes505 views4 answers
Convert date to dd/mm/yyyy sql
SQL
23 votes360 views3 answers
Sql where contains part of string
SQL
0 vote340 views2 answers
Reduce size of SQL server log file truncate - Source :NAYCode.com
SQL
0 vote343 views1 answer
Create table with timestamp mysql youtube
SQL
0 vote382 views1 answer
Psql check table fields
SQL
0 vote337 views1 answer
Select from another database
SQL
6 votes336 views2 answers
Mysql set primary key
SQL
1 vote407 views1 answer
Oracle drop temporary table
SQL
0 vote358 views1 answer
Copy data from cell to cell mysql
SQL