MySQL Forums
Forum List  »  Microsoft SQL Server

Re: Insert into temporary table
Posted by: Roland Bouman
Date: March 16, 2006 09:02AM

yes,


create temporary table my_temp_table(
...
...
..
)


I think you should be able to do:


create temporary table my_temp_table
as
select 'a' as a
union all
select 'b' as a

Options: ReplyQuote


Subject
Written By
Posted
Re: Insert into temporary table
March 16, 2006 09:02AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.