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 vote224 views1 answer
Drop table BigQuery table columns
SQL
5 votes198 views2 answers
Sql number columns
SQL
0 vote211 views1 answer
Sql server update top n records
SQL
0 vote236 views1 answer
Sparql if bound query
SQL
2 votes264 views2 answers
Sql query to copy data from one column to another
SQL
1 vote174 views1 answer
Strict in postgres SQL
SQL
0 vote214 views1 answer
Python sqlalchemy connection show server
SQL
0 vote188 views1 answer
Java spring boot connect to sql server
SQL
1 vote200 views1 answer
ELECT list is not in GROUP BY clause and contains nonaggregated column 'schogdsw_db.SE.name' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
SQL
1 vote287 views3 answers
Showing all columns in an sqlite table
SQL