Getting data from sql into a text file

Article View: bit.listserv.sqlinfo

Article #236

Back to bit.listserv.sqlinfo Previous Next

#236

From: jason
Date: Wed, 16 Aug 2000 00:00

11 lines
997 bytes

Hi,

can someone give me an idea how to take the results of a select query
and save it to a particular text file.

A few hints would be useful. I confused as to whether I do it within SQL
or create a program which at regular intervals will run the select query
to obtain data.

Any help greatly received
Thanks

Technical Details

Message-ID: <399AC724.13246924@sussex.ac.uk>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 11355a,bce8f1e33c453d3d,start
X-Google-Attributes: gid11355a,public
From: jason <jason@sussex.ac.uk>
Subject: Getting data from sql into a text file
Date: 2000/08/16
Message-ID: <399AC724.13246924@sussex.ac.uk>
X-Deja-AN: 658994996
Content-Transfer-Encoding: 7bit
X-Accept-Language: en
Content-Type: text/plain; charset=us-ascii
X-Complaints-To: usenet@newshost.central.susx.ac.uk
X-Trace: ames.central.susx.ac.uk 966444831 8160 139.184.40.67 (16 Aug 2000 16:53:51 GMT)
Organization: University of Sussex
Mime-Version: 1.0
NNTP-Posting-Date: 16 Aug 2000 16:53:51 GMT
Newsgroups: bit.listserv.sqlinfo