Output result of query to existing file

#1

Hi,
I need to output result of my query to txt file. So I'm using -o
parameter, for example:

osql.exe -s (local) -d database1 -U sa -P sa -i 'c:\\queryFile.sql' -o
'c:\\output.txt'

But it clears existing output.txt file first and then outputs the
result, while I need to append the result of my query without clearing
existing file content. Is it possible ?

#2

(mamin (AT) o2 (DOT) pl) writes:

Quote:

I need to output result of my query to txt file. So I'm using -o
parameter, for example:

osql.exe -s (local) -d database1 -U sa -P sa -i 'c:\\queryFile.sql' -o
'c:\\output.txt'

But it clears existing output.txt file first and then outputs the
result, while I need to append the result of my query without clearing
existing file content. Is it possible ?

Use >>, the standard append operator in the command-line environment.

--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Output result of query to existing file

comp.databases.ms-sqlserver comp.databases.ms-sqlserver

Output result of query to existing file - 05-09-2007 , 03:07 AM

Re: Output result of query to existing file - 05-09-2007 , 05:17 PM