SQLTRIGGER Syntax.sql

CREATE TRIGGER Trigger_name -> declraing a trigger with Trigger_name
(AFTER) -> when the trigger will be executed
[ INSERT | UPDATE | DELETE ] -> The operation that can be performed
ON [Table_Name] -> which table to do the operation on
AS
[ Trigger_body ] -> the queries to be executed by trigger

CREATE TRIGGER trigger_name ON ms_customers
AFTER INSERT,UPDATE,DELETE
AS BEGIN 
  SELECT * FROM DELETED 
  SELECT * FROM INSERTED
END

Creates two temporary table called INSERTED and DELETED