Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
rnbguy
Constraint Violating Yak Guru
293 Posts |
 Posted - 2007-02-15 : 01:46:50
|
| ive tried this:exec master..xp_cmdshell ''bcp "select text from texttable" queryout c:\test.txt' -x -c ...but it adds a space after each line, is there a way to remove those spaces or another way to copy table to file? |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2007-02-15 : 01:54:48
|
http://www.mindsdoor.net/SQLTsql/WriteTextFile.html
KH |
 |
|
|
rnbguy
Constraint Violating Yak Guru
293 Posts |
Posted - 2007-02-15 : 02:21:04
|
| my problem is im copying into a table resutls from SP_HELPTEXTwhich when i show the table it is fine but for some reason when i print it to a file it adds spaces |
|
|
|
|
|
|
copy table results to file