multiple row updates in trigger

[TED172]

Hi FORUM,
can any body help me to implement 'trigger for each row concept' like in oracle to be implemented in Sql server.

Ex:-
In my update statement i update 1000rows. I want piece of code in trigger to be used for all the rows got updated.
Triggeri s being fired only once.
I want the trigger to be fired for every row being updated or inserted or deleted.

Any ideas or suggestios is helpful

Thanks
Ted

 

[foxdev]

You can act on each row that was updated by referencing the DELETED (old data) and INSERTED (new data) pseudo-tables. Robert Bradley

http://www.foxdev.com/

Do you have too much money? Visit

http://www.agrainofhope.org