< Previous Question
Next Question >
Is there an equivalent of DUAL in SQL server?
11/10/2018

There is no equivalent of Dual in SQL Server. This is because in SQL Server there is no need to select from a table like in Oracle.

For example

Oracle:

Select col1, col2 from dual

SQL Server:

Select Col1, Col2

info@keyintelligence.uk
01453 767 142
Key Intelligence Ltd
12 The Hill, Merrywalks,
Stroud, GL5 4EP
Registered in England and Wales Company Number: 5182418
The Old Baptist Chapel, New Street, Painswick, GL6 6XH
VAT Registration: 811 3055 77
© 2018 Key Intelligence Ltd. All rights reserved.

By using keyintelligence.uk, you agree to our use of cookies to enhance your experience.