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.
