Table of ContentsPreviousNext

Ispirer
Please, note, that Ispirer SQLWays 6.0 is no longer supported and provided to clients.
You can try out automated conversion of databases and applications with Ispirer Toolkit for free. Download free trial.
Check out the relevant toolkit documentation.
Ispirer Sybase ASA to SQL Server Migration overview.


Ispirer SQLWays Database Migration Software

Returning Non-Table Data as Result Set (Dummy Tables)

This subsection describes techniques to return non-table data as a result set in various databases and their conversion by SQLWays.

Sometimes it is required to return information that not contained in the database tables, as a result set. For example, returning the current user, current date, constants or arithmetic expressions without table columns.

TABLE 71. Returning Non_Table Data and Result Set (Dummy Tables)
Database
Syntax
Description
Sybase Adaptive Server Anywhere
SELECT select_list 
[FROM [SYS.]DUMMY] 
The DUMMY table can be used in Sybase Adaptive Server Anywhere to return non-table result set.
DUMMY is a read only system table that has one row and one column (dummy_col integer NOT NULL).
Use of FROM DUMMY in the FROM clause is optional. If no table is specified in the FROM clause, the table is assumed to be SYS.DUMMY.
Microsoft SQL Server
SELECT select_list 
The SELECT statement without the FROM clause and a variable assignment (@var1=col1) returns non-table result set in Microsoft SQL Server.


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