How to stop SQLServer writing extraneous stuff eg (1 rows affected)

Question

Is there a command I can run inside my SQL script so that it stops outputing information about each operation that gets run?

ie I don't want to see this:

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(Apparently this is in Experts-Exchange, but it's not accessible)

Answer 1

run this command:

set nocount on

Answer 2

SET NOCOUNT ON

and then

SET NOCOUNT OFF

Answer 3

After all these years it still grates. And yes I know how it came to be. But hopefully some day they'll offer "SET COUNT OFF" as an option.