Hi All

What is actual use of inserted and deleted temporary system table in triggers in sql server2000?

what is the importance of using it?

Is there any kind of special situation where we need to use inserted and deleted temporary system table in sql server?

Thanks
monika

Hi Monika,

SQL server stores the temporary data in INSERTED and DELETED table while working on triggers.

OK..

I give u an Example...

If u have just inserted a row in the table T1, u wont be able to get this row from T1 within the Trigger. You can retrieve this row from INSERTED table.

SQL Server uses INSERTED Table for INSERT and UPDATE trigger, DELETED is used by DELETE Triggers.
There is no UPDATED table as some people get confused.

Good Luck,

Akhil