Inserted table in triggers

[dspace]

Is it possible to change the value of a field in the inserted record in a trigger?

I've tried "update inserted" and it won't let me do that.

Thanks.

 

[psprague]

INSERTED is just an instrinsic temp table and will go out of scope when the trigger has finished. If you are trying to do something with the table the trigger is working on, then link the INSERTED table on the PK and update the column in the base table.

If you want to intercept the value before it gets inserted/updated/deleted in the base table, make the trigger an INSTEAD OF (before) rather than a FOR (after). For the before trigger, you will have to provide the insert, update or delete code yourself.