Home Forums SQL Server 7,2000 T-SQL Update field in INSERTED inside trigger RE: Update field in INSERTED inside trigger

  • inserted/updated tables are just views of the log.  when you want to update the value in the record, update against the real table name joining to "inserted" to identify which rows were modified.

    But it would be better to do what you want done in the insert statement.