Sybase Error – Column must be named: %1

In this blog post, you’ll learn more about the Sybase Error Column must be named: %1 and the reason for receiving this error

Sybase SQL Error Message

Column must be named: %1

Reason for this Error

Unnamed columns cannot be used as XML element or attribute names. Unnamed JSON columns can only be used within the top-level SELECT where the tag and parent are defined. In this context, the unnamed column is a directive to generate a JSON value rather than a JSON object for the given column. Name unnamed columns in the SELECT list by using AS.