Sybase Error – Cannot update column ‘%1’ since it appears in the ORDER BY clause

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

Sybase SQL Error Message

Cannot update column ‘%1’ since it appears in the ORDER BY clause

Reason for this Error

You attempted to update a column that appears in the ORDER BY clause. The ansi_update_constraints option controls whether this update is allowed.