Is there an equivalent of DUAL in SQL server?

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


Select col1, col2 from dual

SQL Server:

Select Col1, Col2

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