sql results to a text file

[cards4]

Hello,
I am running a test batch file that runs a sql query and puts the SQL results into a text file. In my query, I tell it to RTrim on all of the string columns. When I view the text file, there are still spaces that appear between the different columns of information. What is it that I can do to get rid of those spaces? Thank you.

 

[mrdenny]

Use BCP to export the data not osql or isql. BCP is a data import/export tool, osql/isql are sql command tools, and are not made for data import/export.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[cards4]

What is BCP?

 

[mrdenny]

BCP is a command line data import/export tool. It's used to load data from a text file into the SQL Server, or exporting data from a table, query or stored procedure to a text file. There is more information available in Books OnLine. You can also bring up a command prompt, and run BCP /? do get the list of paramaers.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com