Non-Table Result Set Conversion from Sybase Adaptive Server Anywhere to Microsoft SQL Server

The DUMMY system table can be used in order to return non-table data as a result set in Sybase Adaptive Server Anywhere.

The SELECT statement without the FROM clause and a variable assignments returns non-table result set in Microsoft SQL Server.

SQLWays removes the FROM [SYS.]DUMMY clause when converting Sybase Adaptive Server Anywhere non-table result sets to Microsoft SQL Server.

Examples:

TABLE 61. Sybase Adaptive Server Anywhere - Microsoft SQL Server Conversion

Sybase Adaptive Server Anywhere	Microsoft SQL Server
SELECT 1 FROM SYS.DUMMY	SELECT 1
SELECT 1 FROM DUMMY	SELECT 1