Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Old Forums
 CLOSED - General SQL Server
 Dummy Table in SQL Server

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2003-04-07 : 07:44:39
Shankar writes "What is the equivalent table in SQL server like Dual in Oracle ie dummy table in sqlserver
Eg:
Select sysdate from dual;"

robvolk
Most Valuable Yak

15732 Posts

Posted - 2003-04-07 : 07:45:24
You don't need a dummy table in SQL Server to get the date:

SELECT getdate()

Most of the functions in SQL Server do not require a table to return a value.

Go to Top of Page
   

- Advertisement -