The SET NOCOUNT ON statement tells SQL Server not to return the message detailing the number of rows affected by a query. It is generally applied to enhance performance and eliminate unnecessary messages in large or complex queries, particularly in stored procedures.
Set NoCount on
Select * from CountryMaster with (nolock)
In above snippet , when you use Set NoCount on that time you will not see affected rows message.
*SET NOCOUNT OFF (By default)
The SET NOCOUNT OFF command reverts to the default mode, in which SQL Server produces the "rows affected" notification following each execution of the query. This is the default and should be used when you wish to monitor the number of rows affected by a query.
Set NoCount off
Select * from CountryMaster with (nolock)
In above snippet , when you use Set NoCount off that time you will see affected rows message.