Sybase Error – Cannot update column ‘%1’ since it does not appear in the SELECT clause

In this blog post, you’ll learn more about the Sybase Error Cannot update column ‘%1’ since it does not appear in the SELECT clause and the reason for receiving this error

Sybase SQL Error Message

Cannot update column ‘%1’ since it does not appear in the SELECT clause

Reason for this Error

You attempted to update a column that does not explicitly appear in the SELECT list. The ansi_update_constraints option controls whether this update is allowed.