Ms SQL triggers

There are two types of triggers: After trigger and instead trigger.

Triggers are mainly triggered for insert, update, delete, and other operations.

The instead of trigger can update the view. I have read this example. A view contains multiple tables, which cannot be directly updated, you can use the instead of trigger to complete this operation.

The update operation first performs the delete operation and then the insert operation. This will generate two temporary tables deleted and inserted.

You can use raiserror to throw an error message.