February 7, 2003 at 12:01 pm
I know I can do this in Oracle
"Select 'Pick a Schema' from dual union Select column1, column2 From my_table"
Can it be done in SQL Server?
February 7, 2003 at 12:22 pm
no
February 7, 2003 at 3:03 pm
dual doesn't work in SQL Server.
select 'pick a schema', ''
union
select col1, col2 from my_table
Steve Jones
February 7, 2003 at 3:07 pm
Steve would "UNION ALL" work faster as the hard coded query is not going to produce duplicates?
Tim C.
//Will write code for food
One Windows to rule them all, One Windows to find them,
One Windows to bring them all and in the darkness bind them
In the Land of Microsoft where the Shadows lie.
Tim C //Will code for food
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply