SQLUSA
 

Microsoft SQL Server 2000

Best Practices

 

How to use the inserted and deleted tables?

 

In a trigger an insert create one row in the inserted table. A delete creates one row in the deleted table. An update creates one row in both.

You can join with the "inserted" and "deleted" tables just like a regular table. These tables are only available in triggers.

 

Best in the World in SQL Server Training
 
SQLUSA.com Home Page