How do I suppress the output of a sql query executed through a batch file

Question

I am executing an sql script through a batch file

sqlcmd /S<machine> /Usa /Paaa123  /i "<sql file>" > "results.txt"

After the above gets executed the resultant file has "(8890 rows affected) " as a part of the result file which I want to suppress.

Possible duplicate http://stackoverflow.com/questions/2014129/is-there-a-way-to-suppress-x-rows-affected-in-sqlcmd-from-the-command-line — David Jashi, Jul 05 '13 at 06:59
That is right David.Not sure if I can mark this question as redundant. — JSS, Jul 05 '13 at 08:02

score 1 · Answer 1 · answered Jul 05 '13 at 07:57

1

Well, if you don't want to export the result of the query execution, just remove the > "results.txt" part.

sqlcmd /S /Usa /Paaa123 /i "" is what you should run

answered Jul 05 '13 at 07:57

Radu Gheorghiu

score 1 · Answer 2 · answered Jul 05 '13 at 08:56

1

Try this:

sqlcmd /S<machine> /Usa /Paaa123  /i "<sql file>" | findstr /v /c:"rows affected" > "results.txt"

answered Jul 05 '13 at 08:56

Ansgar Wiechers

score 1 · Answer 3 · answered Jul 05 '13 at 09:05

1

Try this:

sqlcmd /S<machine> /Usa /Paaa123  /i "<sql file>" | findstr /v /g:"file with unwanted spam" > "results.txt"

answered Jul 05 '13 at 09:05

Endoro

3 Answers3