| Subject | Re: [ib-support] about temp table |
|---|---|
| Author | Helen Borrie |
| Post date | 2003-04-14T11:51:29Z |
At 07:40 PM 14/04/2003 +0800, you wrote:
output set directly from a stored procedure. See the Language Reference
for the FOR SELECT...INTO <output variables> DO...SUSPEND syntax. You
select from such procedures, as you would from a table.
Another option is to define a view and use that where you would need a temp
table in SQL Server...
heLen
>hi ib-supports:In Firebird you have no need of a temp table, since you can generate an
>
>I seems have to use a temp table to support a query.
>But The FireBird1.02 does not support my 'Select ...
>Into ... ' statement. How do I do it? or could anyone
>provide me a temp table example.
output set directly from a stored procedure. See the Language Reference
for the FOR SELECT...INTO <output variables> DO...SUSPEND syntax. You
select from such procedures, as you would from a table.
Another option is to define a view and use that where you would need a temp
table in SQL Server...
heLen