Q9-PE-Demo

CREATE TRIGGER [InsertProduct] ON [Product]
AFTER INSERT --thực hiện trigger sau khi: INSERT, DELETE, UPDATE
AS
BEGIN --thân TRIGGER trong BEGIN END;
    SELECT
        INSERTED.[ProductName],
        [SubCategory].[SubCategoryName]
    FROM
        INSERTED
        INNER JOIN [SubCategory]
        ON INSERTED.[SubCategoryID] = [SubCategory].[ID]
END;

/*
insert into Product(ProductName, UnitPrice, SubCategoryID)
values ('Craft paper', 0.5, 3)
*/