question

snwskr avatar image
snwskr asked

clean data on output

I am trying to run a command line query, but don't want the output to show the status data. I am running it with.. sqlcmd -S ip address -U USER -P password -i "C:\Test.sql" -o C:\Output.txt -W -u -h -1 from some options I saw.. For Example.. I don't want the blank lines or the "(3 rows affected)" to show... 01/30/2018|34749012|34749012|0001637328|12/18/2017|5632|778|XNY 01/30/2018|34752062|34752062|0001606554|12/18/2017|2212|330|HMX 01/30/2018|20515780|20515780|0001599369|12/13/2017|4842|716|HMO (3 rows affected)
sqlcmd
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Jon Crawford avatar image
Jon Crawford answered
You can SET NOCOUNT ON
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.