A Simple trigger example

The below is simplest trigger that execute while any record is inserted in the table tbl_registrations and while insert operation is complete it displays all the values inserted in the table


Create trigger tr_MyTrigger1
ON tbl_registrations
FOR INSERT
AS
Begin
        SELECT * FROM Inserted
End