Close this search box.

Is there a “DUAL” database equivalent in SQL Server?

There isn’t a “DUAL” exactly, but you can test things out in SQL Server in a similar way for example in Oracle to get today’s date/time you would type:

SQL> SELECT sysdate from DUAL;

To do the same thing in MS SQL Server type:

SELECT getdate()

Print | posted @ Tuesday, June 10, 2008 6:29 AM

This article is part of the GWB Archives. Original Author: Ask Paula

Related Posts