devxlogo

Save on Network Traffic with the Transact-SQL Statement SET NOCOUNT ON

Save on Network Traffic with the Transact-SQL Statement SET NOCOUNT ON

All statements executed in a stored procedure, including SELECT statements, generate an “x rows affected” message. These messages are typically not needed by the application when it is executing a stored procedure. Applications can execute the T-SQL statement SET NOCOUNT ON, so that the SQL Server does not return an indication of how many rows were affected by SQL statements, or by any statements within procedures. Issuing this command at the start of a large stored procedure can significantly reduce the network traffic between the server and client, and improve performance by eliminating these messages.

See also  Small Business Strategies with Venmo
devxblackblue

About Our Editorial Process

At DevX, we’re dedicated to tech entrepreneurship. Our team closely follows industry shifts, new products, AI breakthroughs, technology trends, and funding announcements. Articles undergo thorough editing to ensure accuracy and clarity, reflecting DevX’s style and supporting entrepreneurs in the tech sphere.

See our full editorial policy.

About Our Journalist