What is the SQL Server's equivalent to the DUAL table in Oracle?

PaullyB · Feb 1, 2001

I am new to SQL Server. I am curious if there is a SQL Server equivalent to the DUAL table in Oracle?

Thanks,

PB

wushutwist · Feb 1, 2001

There not really a similar psuedotable in SQL Server that I know of, but you can achieve the same effect.

Oracle

Code:

SELECT sysdate
FROM dual;

SQL Server T-SQL

Code:

SELECT getdate()
GO

Wushutwist

TomSark · Feb 2, 2001

In SQL Server, you don't have to specify FROM DUAL; Tom Davis
tdavis@sark.com