>>The inserted and deleted tables are special tables available in Triggers. In SQL Server 2005 and up you can also access them using OUTPUT clause
http://weblogs.sqlteam.com/mladenp/archive/2006/06/08/10122.aspx.
>>
>>In DELETE command Deleted table would contain record(s) that was(were) deleted
>>
>>In UPDATE Deleted would contain original values (before the update) and Inserted would contain new values
>>
>>In Insert Inserted will contain just inserted records.
>
>
>Ahh, I see. Thanks!
You're welcome.
If it's not broken, fix it until it is.
My Blog