Hello everyone I want to ask us what is the deference between trigger with instead of and trigger with for and finally thanks

Question

😍😍
https://code.sololearn.com/c7oNU1s7yevn/?ref=app

Answer 1

An Trigger with Instead is a trigger that allows you to skip an INSERT, DELETE, or UPDATE statement to a table or a view and execute other statements defined in the trigger instead.

An Trigger with For is fired only when all operations (INSERT, UPDATE or DELETE) specified in the triggering SQL statement have executed successfully

Answer 2

Thank you bro