Up Prev Next
From: Simon Haven <Simon dot Haven at wdr dot com>
Subject: Re: How can I get the speed I need?
Date: Jul 20 1999 12:59PM
You could create a view of the columns you want, in the format and order you want them, and then BCP that out (depending on which version of Sybase you're running)
I've done this many times and it saves a lot of pain.
Hope that helps,
Begin forwarded message:
To: SybPerl Discussion List
Subject: RE: How can I get the speed I need?
Date: Tue, 20 Jul 1999 13:35:09 +0100
X-Priority: 3 (Normal)
X-Mailer: Microsoft Outlook 8.5, Build 4.71.2173.0
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.2106.4
X-Sender: "Peter Collard"
X-Listprocessor-Version: 8.2.07 -- ListProc(tm) by CREN
how about select into?
Peter Collard (x3863)
Senior Sybase DBA
The views expressed in this correspondence are those of the author and
do not necessarily represent those of Rabobank International