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