SQL server database management system course, web design profession, Dalat College of Technology - 14
NHATKYBANHANG Table We can see that the quantity of item with H2 code is 40 (reduced by 5) while it should be 35 (reduced by 10). So the above trigger is not working properly in this case. To fix the above error, we redefine the trigger as follows: CREATE TRIGGER trg_nhatkybanhang_update_soluong ON ...












