How to stop SQLServer from writing extraneous things, for example (1 row affected)

Question

Is there a command that I can run inside my SQL script so that it does not display information about each running operation?

those. I do not want to see this:

(1 row(s) affected) (1 row(s) affected) (1 row(s) affected) 

Answer 1

 SET NOCOUNT ON 

and then

 SET NOCOUNT OFF 

Answer 2

run the following command:

 set nocount on