End-User Documentation

QL0061 Computed Column Write

QL0061 Computed Column Write

The statement attempts to write to a computed column according to the loaded schema snapshot.

When It Appears

  • Computed columns are read-only from the perspective of application writes
  • This applies to schema-backed INSERT and UPDATE validation

Example

var update = new SqlUpdate("UPDATE dbo.orders SET total_with_tax = @Value WHERE order_id = @Id");

Next Steps

  • Remove the computed column from the write target list
  • Query the computed value after the row is written instead of setting it directly