Inside the trigger, you will have access to two virtual tables
'inserted' & 'deleted'. For an insert, all the inserted rows will
be in the inserted table, for a delete, all the deleted rows will
be in the deleted table and for an update, the rows with the older
(before update) values are in the deleted and the rows with the
newer (after update) values are in the inserted tables.
To find out the rows affected, depending on your requirements, you
may want to join with the inserted or deleted table in the trigger
code. Refer to SQL Server Books Online for more details.
(Please respond only to newsgroups)