User Documentation
Ispirer Capabilities - Microsoft SQL Server Migration
Pricing
Microsoft SQL Server - Returning Information as Result Set (Dummy Tables)
You can use a standalone SELECT statement without the FROM clause to return a single row data as a result set in SQL Server. There is no need to use “dummy” tables or conditions (that are guaranteed to contain 1 row).
Example (SQL Server):
SELECT GetDate()
This query returns the current date and time as a result set.
Dummy Tables - Differences between SQL Server and other Databases
| Database | Returning Result Sets |
|---|---|
| Oracle | SELECT … FROM dual |
| Informix | Informix dummy tables - SELECT … FROM systables WHERE tabid=1 |