hi
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 ?