nocount (which can be on or off) specifies if SQL Server sends a message about the numbers of records affected to the client after executing one of the following SQL statements: select
insert
update
merge
delete set nocount on statement as first statement in a procedure.