What is the use if set nocount on in SQL Server

Last Reply on May 16, 2012 09:19 AM By Mudassar

Posted on May 16, 2012 09:18 AM

HI every one

can you explain about this code in sql?

SET NOCOUNT ON

why we write this code in procedure?

thanks

Posted on May 16, 2012 09:19 AM

It improves performance by stopping SQL Server calculate number of rows affected

http://www.mssqltips.com/sqlservertip/1226/set-nocount-on-improves-sql-server-stored-procedure-performance/