Row Level Trigger

How can i write a trigger which gets fired for each row that is being deleted

i.e. Row level TriggerI tried something like this

ALTER TRIGGER [dbo].[Del_Msg] ON [Seat27].[dbo].[Email_Messages] AFTER DELETE&......

it gets executed once for the triggering SQL statement

Oracle provides row and statement level triggers.

Sql Server does not. Instead, it provides statement level triggers with access to row-level information.

There are two dummy tables, @.inserted and @.deleted available inside your trigger.

If a record is in both tables, it was updated. Otherwise, it was inserted or deleted as obvious.

Your trigger needs to perform whatever row-oriented tasks it needs to do using the dummy tables for input.

|||Thanx