Performance optimization: SQL Server shuts down the output of the affected number of rows

Little scum · Posted on 9/21/2022 6:59:42 PM

When executing a SQL script in the SQL Server database, the SQL script updates the data in a loop, and the data volume is relatively large, and the execution result will output a large amount of information affecting the number of rows, as shown in the figure below:

How do I turn off the output of affected rows? Enter on the first line of the scriptSET NOCOUNT ON, measured the execution scriptThe speed is much faster, saving half a minute of time。

SET NOCOUNT

Causes the returned results to contain no information about the number of rows affected by the Transact-SQL statement.

grammar

SET NOCOUNT { ON | OFF }

exegesis

When SET NOCOUNTWhen ON, no count is returned(indicates the number of lines affected by the Transact-SQL statement). When SET NOCOUNT is OFF, the count is returned.

scope

set nocountThe scope is the current session, which means that it will remain active as long as the session does not turn off the nocount setting.

Reference Documentation:The hyperlink login is visible.

[Source] Performance optimization: SQL Server shuts down the output of the affected number of rows

Related Posts

Sections viewed