Assuming that the table and column names are correct, consid…
Assuming that the table and column names are correct, consider the following trigger: CREATE TRIGGER Product_Insert_Update ON Product AFTER INSERT, UPDATE AS UPDATE Product SET ProductCategory = LOWER(ProductCategory) WHERE ProductID IN (SELECT ProductID FROM Inserted) – the inserted ProductID ; What is the effect of running the following statements? INSERT INTO Product(ProductID, ProductName, ProductCategory) VALUES (‘1235453′,’Alpha 39′,’Alpha’); SELECT ProductID, ProductName, ProductCategory FROM Products WHERE ProductID = ‘1235453’;