开发者

Suppress SQL Output

开发者 https://www.devze.com 2022-12-16 00:06 出处:网络
When running a SQL query with output to text we typically get back output like this. AssetIDOccurs -------------------- -----------

When running a SQL query with output to text we typically get back output like this.

AssetID              Occurs
-------------------- -----------

(0 row(s) affected)

Since I am doing thousands of select statemen开发者_如何学JAVAts to audit data in my table is there a way to suppress this output on SQL server?


If you want to suppress the whole block you've shown then you'd need to do:

SET NOCOUNT ON

...

IF EXISTS(SELECT AssetId FROM Table)
BEGIN
    SELECT AssetId, Occurs FROM Table
END


Prefix the query with:

set nocount on

to suppress to rowcount messages. You can disable column headers in SSMS, under Tools -> Options - > Query Results -> Results To Text.

As for the rows themselves, you could suppress them by adding a clause like where 1=0, but then I wonder why you select them in the first place.

0

精彩评论

暂无评论...
验证码 换一张
取 消