SQLcmd output contains also unwanted input SQL statements

Question

I created a sql script that retrieve some information from database as a table format,

I have create a sqlcmd script that execute that query file, but in the output file I have the queries present in the .sql file + the results that are saved, result file http://prntscr.com/7e4j5i

I want only to have the result in that file

SQLCMD -S pcname\SQLEXPRESS -v VITI=%vl% -E -w 166 -e -i C:\db\input.sql -o C:\db\Book1.csv -s","  -w 700 -es

How can I do it?

Do I have to change something in the .sql file to exclude the queries from the results file?

Donal · Accepted Answer · 2015-06-08 15:25:07Z

2

Remove the -e parameter.

The -e parameter will echo the input (i.e. your SQL).

For info, see here.

edited Jun 8, 2015 at 15:25

answered Jun 7, 2015 at 11:37

Donal

33.2k10 gold badges69 silver badges75 bronze badges

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

Collectives™ on Stack Overflow

SQLcmd output contains also unwanted input SQL statements

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related