Correct Output to File When Using SQLCMD

Question

I've been playing around with SQLCMD to output a .SQL results to a file. It is working but the actual SQL statements are also being displayed in the output file which I obviously don't want. I am using a .bat file to run the SQL File. The following command is what I have in my .bat:

SQLCMD -S MyServerName -d MyDBName -i C:\test\start.SQL -o C:\test\out.txt -e

In my start.SQL I have the following:

set nocount on
    SELECT '<HEADER>', getDate(), '<HHEADER>'

SELECT UPPER(ACCTNUM), 
CONVERT(VARCHAR(10),DATEEXP,126),
UPPER(OPERID),
CONVERT(VARCHAR,CREATE_TMSTMP,120)

FROM RETURNS
WHERE CREATE_TMSTMP < getDate()
AND CREATE_TMSTMP > getDate() - 1


SELECT '<TRAILER>', getDate(), '<HHEADER>'

set nocount off

In the output file the correct information is shown but it's a little ugly with dashes and such and even shows the SQL command that was executed. Is there any way to fix this problem. Am I doing something wrong here? Any help would be greatly appreciated.

Gary Walker · Accepted Answer · 2014-05-11 01:28:07Z

1

Why are you using the -e option?

-e Writes input scripts to the standard output device (stdout).

answered May 11, 2014 at 1:28

Gary Walker

9,2043 gold badges22 silver badges43 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Tastybrownies Over a year ago

Added the nocount, took away the GO's, and took away that -e like you suggested and everything is clean. Thank you very much!

RGuggisberg · Accepted Answer · 2014-05-11 01:42:37Z

0

The dashes are part of the header. Use -h-1 to specify no header. If that is not acceptable use something like FINDSTR /B /V "----" to exclude that header line... assuming none of the lines you want to keep start with dashes.

answered May 11, 2014 at 1:42

RGuggisberg

4,7802 gold badges21 silver badges29 bronze badges

Collectives™ on Stack Overflow

Correct Output to File When Using SQLCMD

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related