News

Copyright © 2008-2016 Paula DiTallo

Tag Cloud


June 2008 Entries


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()