Running SQL from command line

[KEMoore]

Hello,
I am using SQl 2000 and running several stored procedures from a batch file. I want to be able to run a few small queries at the end of the file and export the results to a text file.
So far, all I've managed to do is take the output from the command line and export it. Is my desired result possible?


OSQL -U login -P Password -d Database -i MYQRY.sql >>-o C:\Results.txt


Thanks,
K

[ck9663]

Hello,
I am using SQl 2000 and running several stored procedures from a batch file. I want to be able to run a few small queries at the end of the file and export the results to a text file.
So far, all I've managed to do is take the output from the command line and export it. Is my desired result possible?


OSQL -U login -P Password -d Database -i MYQRY.sql >>-o C:\Results.txt


Thanks,
K

i think it's possible. have you tried:

OSQL -U login -P Password -d Database -i MYQRY.sql -o C:\Results.txt


-- CK

[KEMoore]

Thank you for your response.
I have tried that. It prints what I see in the command window.
I was looking for something uniform that did not have the column names and the "------".
Thanks!

[KEMoore]

I was able to use a BCP command to export my results to a text file.
Wow, I can't believe I missed that the first time around.

Thanks
K