Given this trigger: CREATE TRIGGER RoundPriceBEFORE INSERT…
Given this trigger: CREATE TRIGGER RoundPriceBEFORE INSERT ON SellsFOR EACH ROWSET NEW.price = ROUND(NEW.price); A User attempts to execute the following statement on Sells (Bar, Beer, Price): INSERT INTO Sells (bar, beer, price) VALUES (‘Joe”s Bar’, ‘Corona’, 4.75); What will happen to the price value inserted into the Sells table?
Read Details