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

10 votes320 views4 answers
Fetch first 5 characters of the string in sql
SQL
34 votes398 views6 answers
Alter table add foreign key mysql
SQL
6 votes335 views2 answers
Stored procedure to delete data from table in mysql
SQL
0 vote328 views1 answer
Select STR_TO_DATE(date_seance1,'DD-MM-YYYY')
SQL
3 votes336 views1 answer
Créer une table sql
SQL
0 vote363 views1 answer
For select oracle
SQL
0 vote393 views1 answer
Generate a random otp in sql server
SQL
1 vote321 views1 answer
Are NULL values in a database the same as that of blank space or zero?
SQL
5 votes327 views1 answer
Alter table add comment oracle
SQL
9 votes356 views3 answers
Pyodbc connect to sql server
SQL