Table of ContentsPreviousNext

Ispirer             Ispirer

Ispirer SQLWays Database Migration Software

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 72. 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

Table of ContentsPreviousNext
Ispirer             Ispirer
Copyright © 1999-2015 Ispirer Systems Ltd. Ispirer and SQLWays are trademarks of Ispirer Systems Ltd. All other product names may be trademarks of the respective companies. All rights reserved.