Use SetNoCountOn when writing a stored procedure. By default, the stored procedure returns the number of rows affected by each statement in the process. If you do not need to use this information in the application (most applications do not need to use SET NOCOUNT ON
By default, the stored procedure returns the number of rows affected by each statement in the process. If you do not need to use this information in an application (not required by most applications), use the set nocount on statement in the stored procedure to terminate this action. Based on the number of statements that affect the row contained in the stored procedure, this will delete one or more round-trips between the client and the server. Although this is not a big problem, it can negatively affect the performance of high-traffic applications.
Create procedure test_MyStoredProc @ param1 int
As
Set nocount on
When set nocount on by default, the stored procedure returns the number of rows affected by each statement in the process. If you do not need to use this information in the application (most applications do not need this information...
