Re: Export SQL statement from query to text file

From: W Dean (wodgedean_at_hotmail.com)
Date: 05/20/04 

Date: Thu, 20 May 2004 13:49:18 +0100

There's about a 150 of them! So it'll take ages :-(

"Andrew L." <andrew@aelay***.fsnet.co.uk> wrote in message
news:c8hk4u$4om$1@news6.svr.pol.co.uk...
> What's wrong with the good old copy/paste routine?
>
> Switching to SQL view automatically selects the block of text. Ctrl-C ,
open Wordpad or similar,
> Ctrl-V, Ctrl-S.
>
> hth
> Andrew L.
>
> "W Dean" <wodgedean@hotmail.com> wrote in message
news:OuznqsdPEHA.3988@tk2msftngp13.phx.gbl...
> > Hi,
> >
> > Is there an easy way to save a query or queries (ie, the sql from them)
as a
> > text file?
> >
> > I tried using documenter but it doesn't export delete statements and
also
> > seems to truncate some queries,
> >
> > W Dean
> >
> >
>

Loading