sql server new users:

An Update to data in a table fires an Update Trigger.

In the Update Trigger, you have access to the virtual tables INSERTED and
DELETED. Those 2 tables represent the data before and after the update
statement occurred.

Regards
--------------------------------
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland

IM: mike@epprecht.net

MVP Program: http://www.microsoft.com/mvp

Blog: http://www.msmvps.com/epprecht/

[quoted text, click to view]