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 vote102 views1 answer
Get number of tables in database sql
SQL
3 votes130 views3 answers
Order by postgres
SQL
0 vote122 views1 answer
Postgres get database encoding
SQL
0 vote103 views1 answer
Subquery aggregation
SQL
1 vote104 views1 answer
Mysql backup skip table
SQL
1 vote107 views1 answer
Postgres convert date to string
SQL
0 vote123 views1 answer
How to fetch data from database in sql
SQL
0 vote107 views1 answer
Remove mysql from centos 7
SQL
0 vote107 views1 answer
Https://www.jitendrazaa.com/blog/sql/sqlserver/export-documents-saved-as-blob-binary-from-sql-server/
SQL
0 vote125 views1 answer
Stored procedure to change name of column for all dependent tables and views
SQL