Breaking News: Grepper is joining You.com. Read the official announcement!

SET NOCOUNT ON;

ekkamrit answered on July 19, 2022 Popularity 10/10 Helpfulness 5/10

answer SET NOCOUNT ON;

SET NOCOUNT ON;

Comment

SET NOCOUNT OFF – By default, SQL Server shows the number of affected rows in 
the messages pane
SET NOCOUNT ON – We can specify this set statement at the beginning of the 
statement. Once we enable it, we do not get the number of affected rows in the 
output.
-- When NOCOUNT is set to ON, the SQL Server does not have to send the number 
-- of rows affected message to the client for each statement.

Popularity 10/10 Helpfulness 5/10 Language sql

Source: www.sqlshack.com

Tags: nocount set sql

Link to this answer
Share Copy Link

Contributed on Jul 19 2022

ekkamrit

0 Answers Avg Quality 2/10

Continue with Google

By continuing, I agree that I have read and agree to Greppers's Terms of Service and Privacy Policy.

SET NOCOUNT ON;

Contents

More Related Answers

SET NOCOUNT ON;

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.