Getting List of added/deleted records in trigger

To list of all records that has been added in a table for which trigger executed
records

SELECT * FROM Inserted

To list of all records that has been deleted in a table for which trigger executed
records

SELECT * FROM Deleted


To list of all records that has been modified but not delete modified in a table for which trigger executed
records


SELECT * FROM Inserted
EXCEPT
SELECT * FROM Deleted