Suppress “affected rows” Output in MS SQL Server
Friday, June 22nd, 2007It gets a little annoying when you’re writing a log in your SQL script, only to have it cluttered with (x row(s) affected) statements. These can be very easily disabled by using the following command:
SET NOCOUNT ON
