SAP Knowledge Base Article - Preview

2070433 - Error -185 "SELECT returns more than one row" on execution of SELECT <variable> = <column> FROM <table> WHERE <condition> - SQL Anywhere

Symptom

  • Procedure is written in the Transact-SQL syntax
  • Variable gets set based on a query that returns zero to n rows
  • The format of the statement is: SELECT <variable> = <column> FROM <table> WHERE <condition>
  • The execution of the statements results sometimes in error -185 "SELECT returns more than one row"


= FROM WHERE - SQL Anywhere"> Read more...

Environment

SAP SQL Anywhere

Product

SAP SQL Anywhere all versions ; SQL Anywhere all versions

Keywords

TSQL, T-SQL syntax , KBA , BC-SYB-SQA , SQL Anywhere (on premise, on demand) , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.