Need help with Removing ---------- characters from xml format data file

Question

Hi All,

I'm using below command to generate the xml format data in .txt file but I'm getting the ---------------------------- characters lines in the file at beginning of the data, could you someone help me that how to remove these while generating file.

Command: sqlcmd -S servername -d test -E -Q "SP_Name" -o "\ServerName\Folder\filename.txt"

Output:

ColumnName

---

<DATAROW><COLUMN NAME="NM">12345</COLUMN><COLUMN NAME="TP">3</COLUMN></DATAROW>

Thanks In Advance.
Vasu

Answer 1

Another option if you do not need the headers and you need to export the data to a text file and you want better performance, is to use bcp instead of sqlcmd

Answer 2

-Q "SP_Name"

And what do the stored procedure (as I guess) return when you execute it in SSMS?

Answer 3

Hi @SM ,

To remove column headers, use the -h -1 to remove the dashes (--------) from the output

https://stackoverflow.com/questions/24497970/sqlcmd-to-generate-file-without-dashed-line-under-header-without-row-count

-------------

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.