tsql - MS SQL Server 2008 changing inserted row value in trigger -

in oracle can change row value :new.column_name = new_value in insert/update trigger. how can same in ms sql 2008 trigger?

unlike oracle, affected records passed in sets sql server triggers, referenced inserted , deleted.

you have update target table:

update   m set      column_name = @new_value     inserted join     mytable m on       m.id = i.id 

or, better, create instead of trigger.