December 10, 2008 at 1:54 am
Dear All,
is there any system table available in TSQL like we have
'select * from dual' in oracle .
Thanks in Advance!
Regards,
Sabari.C
December 10, 2008 at 2:05 am
There's isn't a 'dual' table in SQL. What do you need it for?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 10, 2008 at 2:08 am
i need for to run the single line statement in Tsql without using any specific tables ..
December 10, 2008 at 2:15 am
sabarichandru (12/10/2008)
i need for to run the single line statement in Tsql without using any specific tables ..
Why don’t you specify what you need? If all you want is to run a t-sql line without specifying table name, just run select 2, getdate(), @@version. Of course this is not what you wanted to see, but since you don’t specify your needs, how can anyone here help you?
Adi
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
December 10, 2008 at 5:34 am
sabarichandru (12/10/2008)
i need for to run the single line statement in Tsql without using any specific tables ..
Unlike in Oracle, SQL doesn't require the from clause or a table to be specified within a select. Hence there's no dual table and no need of one.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply