What is the equivalent of Oracle SQL Server SET NOCOUNT ON?
From the SQL Server documentation :
SET NOCOUNT ON ... Stops a message in which the counter of the number of rows referenced by the Transact-SQL statement or stored procedure is returned as part of the result set ...
For stored procedures that contain multiple statements that do not return a lot of actual data, or for procedures that contain Transact-SQL loops, setting SET NOCOUNT to ON can provide significant performance improvements because network traffic is significantly reduced.
source
share