MS SQL Server - results to a textfile

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

results to a textfile

Christian Risager

2005-11-30, 3:23 am

Hi there

I want to write the results of a select-sql to a textfile - the select is
executed from a stored procedure.

I have looked through the booksOnline, but couldn't find anything usefull.

Does anyone have a sample or something that shows how to write the result of
a select to a textfile?

Regards

chr

Jens

2005-11-30, 3:23 am

Look in the BOL for OSQL and the -o switch for an output file.

http://msdn.microsoft.com/library/d...mta_01_2r1e.asp

HTH, Jens Suessmeyer

Sponsored Links