SET NOCOUNT ON statement usage and performance

SQL SET NOCOUNT ON

SQL Server SET NOCOUNT ON/OFF statement that controls the behaviour in SQL Server to shown the number of affected rows in the T-SQL query.