Re: temporary table

Article View: borland.public.cppbuilder.database.ado

Article #4509

Back to borland.public.cppbuilder.database.ado Previous Next

#4509

From: brahim
Date: Wed, 12 Dec 2001 11:43

15 lines
1258 bytes

if your msdb is able to create temporary tables it would be very easy

syntax:
create table #<name> ...
select * from #<name>

# indicates that <name> is a local temporary table
## means global temporary

you must perform everything without closing connection

Havn't tested with BCB
hope this helps

brahim

Technical Details

Message-ID: <3C1742CA.EE716E7B@magcom.fr>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-03!supernews.com!newsswitch.lcs.mit.edu!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!newsfeed.media.kyoto-u.ac.jp!newsfeed.mesh.ad.jp!osa.uu.net!newsfeeds.ihug.co.nz!ihug.co.nz!dnews

References: <3c146676$1_2@dnews>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,414943b9bdc101ff
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2001-12-12 05:17:55 PST
Message-ID: <3C1742CA.EE716E7B@magcom.fr>
Date: Wed, 12 Dec 2001 12:43:07 +0100
From: brahim <brahim@magcom.fr>
Organization: magcom
X-Mailer: Mozilla 4.76 [en] (Win98; U)
X-Accept-Language: en
MIME-Version: 1.0
Newsgroups: borland.public.cppbuilder.database.ado
Subject: Re: temporary table
References: <3c146676$1_2@dnews>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 217.128.21.35
X-Trace: dnews 1008157514 217.128.21.35 (12 Dec 2001 03:45:14 -0800)
Lines: 17
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-03!supernews.com!newsswitch.lcs.mit.edu!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!newsfeed.media.kyoto-u.ac.jp!newsfeed.mesh.ad.jp!osa.uu.net!newsfeeds.ihug.co.nz!ihug.co.nz!dnews

Reply to Parent Message