數(shù)據(jù)庫編程總復(fù)習(xí)(思考題、實驗解答)-資料下載頁
2025-01-12 11:35本頁面
【正文】 TRIGGER mytrigger ON /*填空 */ for /*填空 */ AS BEGIN declare @pid char(6),@new_quantity int,@old_quantity int select @pid=productid,@new_quantity=quantity from inserted select @old_quantity=quantity from /*填空 */ update /*填空 */ set /*填空 */ where /*填空 */ END 41 實驗解答 默認的觸發(fā)器類型： USE sales go CREATE TRIGGER mytrigger ON OrderDetails for UPDATE AS BEGIN declare @pid char(6),@new_quantity int,@old_quantity int select @pid=productid,@new_quantity=quantity from inserted select @old_quantity=quantity from deleted update products set stocks=stocks+@old_quantity @new_quantity where ProductID=@pid END 42 實驗解答 前觸發(fā)器： USE sales go CREATE TRIGGER mytrigger ON /*填空 */ INSTEAD OF UPDATE AS BEGIN declare @pid char(6),@new_quantity int,@old_quantity int select @pid=productid,@new_quantity=quantity from inserted select @old_quantity=quantity from /*填空 */ update /*填空 */ set /*填空 */ where /*填空 */ END 43 實驗解答 前觸發(fā)器： USE sales go CREATE TRIGGER mytrigger ON OrderDetails INSTEAD OF UPDATE AS BEGIN declare @pid char(6),@new_quantity int,@old_quantity int select @pid=productid,@new_quantity=quantity from inserted select @old_quantity=quantity from deleted update products set stocks=stocks+ @old_quantity @new_quantity where ProductID=@pid END
教學(xué)課件相關(guān)推薦
鄂ICP備17016276號-1