Function of set nocount on

 

Set nocount on is often used in the stored procedure;

Purpose: prevents returned results from displaying row count information affected by T-SQL statements or USP.
When set oncount on, no count is returned. When set nocount off, the count is returned;

Update @ rowcount even when set nocount on;

When set nocount on, the done_in_proc message of each statement in the stored procedure is not sent to the client. If the Stored Procedure contains statements that do not return actual data, the network communication traffic will be greatly reduced, can significantly improve applicationsProgramPerformance;

The setting specified by set nocount takes effect during execution or running, but does not take effect during analysis.

Set nocount off

1 Use northwind2 Go3 Set nocount off;4Select top5Orderdate from orders5Go
 

Result set display:

Set nocount on

1 SetNocountOn;2 Select Top 5OrderdateFromOrders3 Go