...bringing you notes from the field...

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