i would like to write a trigger for the basic operations on a table : insert, delete, update.
i know the basic syntax:
create trigger on tbl_MyReports for insert,delete,update as
my question is how can i know which rows changed ?
if i inserted or deleted or updated a row or many rows how can i know which row changed and how can i access the rows columns ?