Trigger on inserted or updated record only 1

[thromada]

Hi All,
If I use CREATE Trigger NAME On TABLE For Insert, Update
As UPDATE TABLE SET field = value FROM TABLE WHERE CONDITION... how can this type of trigger be changed to affect only the CURRENT RECORD that's being inserted or updated? I don't know how to tell the WHERE CONDITION (or any other portion) to only work with the record that's being inserted or updated.

Thanks much.
Tom.

 

[jbenson001]

Use the logical table "inserted". It holds the row currently being inserted or updated. It has the same column structure as your table. You just need to join to it.

Jim

 

[thromada]

That was it, thanks!

 

[jbenson001]

No problem, glad to help

Jim