CODE EXAMPLE FOR SQL

SET NOCOUNT ON;

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