News

Copyright © 2008-2018 Paula DiTallo

Tag Cloud



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

Tuesday, June 10, 2008 6:29 AM

Feedback

# re: Is there a "DUAL" database equivalent in SQL Server?

Hi

In sql server nothing is like as dual so what ever you want to do

You can does through direct select st..

for example

select (1+1)

select 'hello'

select 'hello' message


and so on.... 9/15/2014 6:55 AM | Rupa

# re: Is there a "DUAL" database equivalent in SQL Server?

i want to use union like this
====================================
Select '0' as ID, '--choose--' as Description
from Dual
union
Select ID, Description
from abc

this is work in oracle but now i want to use in Sql server how is possible? any one have idea? 5/16/2016 1:50 PM | aliRana

Post A Comment
Title:
Name:
Email:
Comment:
Verification: