The CREATE TRIGGER statement provides for two types of triggers: AFTER triggers and INSTEAD OF triggers. Both types of triggers can be defined to fire for an insert, update, or delete operation. If an action query has an AFTER trigger, the trigger fires after the successful completion of action query. If an action query has an INSETEAD OF trigger the trigger is fired instead of the action query. In other words the action query is never executed.
–How can create trigger with encryption
CREATE TRIGGER TempTriggerfordelete
ON tbl_Employee WITH ENCRYPTION
INSTEAD OF DELETE
PRINT ‘delete trigger fired. Cannot insert values in the table TempTable.’