Ispirer Website Ispirer Capabilities - Microsoft SQL Server Migration Free Trial

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

© 1999-2024, Ispirer Systems, LLC. All Rights Reserved.