StatCounter

View My Stats

Tuesday, February 5, 2008

Purpose of SET NO COUNT ON inside the stored Procedure-SQL Server

If u dont use SET NO COUNT ON inside the stored procedure the DONE_IN_PROC Message each time send to the caller..For the Concern insert,delete,update operation taken.

This is the Performance issue.In order to overcome the use
SET NO COUNT ON inside the Stored Procedure

No comments: