Writing to a text file 1

[AndyLee100]

Is there anyway using T-SQL that a query can write to a text file that could be saved to the local disk drive.

Thanks in advance

Andy

 

[nigelrivett]

See

http://www.nigelrivett.net/WriteTextFile.html

For a few popular ways - there are lots more.


======================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.

 

[AndyLee100]

Nigel,

Nice one. Thanks for the link, will take a look at the other topics on your web site in due course.

Have a star.

Andy