CODEWITHSUNDEEP
sql-serverrowssqlcmdsuppress
Josh Kodroff
Josh Kodroff

Reputation: 28121

Is there a way to suppress "x rows affected" in SQLCMD from the command line?

Is there a way to suppress "x rows affected" in SQLCMD from the command line?

I'm running an MSBuild script and don't want it clogging up my log on my build server.

I'd rather not have to add "SET NOCOUNT ON" in every script, so if there's a way to do it from the command line, that would be fantastic.

Upvotes: 104

Views: 117791

Answers (3)

Cade Roux
Cade Roux

Reputation: 89671

The -i and -q options are mutually exclusive.

Create a file named setnocount.sql with the content:

SET NOCOUNT ON;

And you might be able to do -i setnocount.sql,otherscript.sql using the multiple files feature and effectively an "included" common first file.

Upvotes: 61

Rob
Rob

Reputation: 561

You can also run multiple lines in the -Q parameter, separated by semicolon, like below

eg:

-Q "set nocount on;select * from table;delete from table where some_condition=true"

Upvotes: 56

fupsduck
fupsduck

Reputation: 3189

What about creating a startup script with SET NOCOUNT ON in the script (assign the script to the SQLCMDINI environment variable). http://msdn.microsoft.com/en-us/library/ms162773.aspx

Upvotes: 106

Related Questions