Re: temporal tables

From: Tom Best <tom.best_at_bentley.com>
Date: 2000/08/02
Message-ID: <8m9lm7$oaa$1@news.bentley.com>#1/1

Luis:

You can do something like this:

create global temporary table xxx (a int); insert into xxx select i from x;

HTH,
Tom Best

J. Luis <jl.alvarez_at_wanadoo.es.xxx> wrote in message news:38Xh5.100$%m6.3629_at_m2newsread.uni2.es...
> how cai i insert a result of a query in a temporal table?
> i tried to do "select * from name_table into temp prueba" and it doesn´t
> work¡¡¡
> arre there other instruction insteed into temp temp_table????
>
> thanks
>
>
Received on Wed Aug 02 2000 - 00:00:00 CDT