刪除觸發(fā)器語句sql 關(guān)于SQL Server觸發(fā)器instead of delete使用問題？
關(guān)于SQL Server觸發(fā)器instead of delete使用問題？create trigger tri_instead_delon studentinstead of deleteasbegi
關(guān)于SQL Server觸發(fā)器instead of delete使用問題？
create trigger tri_instead_delon studentinstead of deleteasbegin declare @courseId varchar(50) --定義編號(hào)變量。 --在deleted表中查詢要?jiǎng)h除的編號(hào) select @courseId=stu_idfrom deleted delete from score where stu_id=@courseId delete from student where stu_id=@courseId --其中就要通過deleted表來查詢要?jiǎng)h除的編號(hào)endINSTEADOF觸發(fā)器：它在執(zhí)行INSERT、UPDATE、DELETE語句操作之前執(zhí)行觸發(fā)器本身所定義的操作。而INSTEADOF觸發(fā)器是可以定義在視圖上的