My Tasks App
Java For Beginners
Search This Blog
How to reduce amount of network data for SQL server stored procedure?
SET NOCOUNT ON
Every time a SQL Statement is executed it returns the number of rows that were affected.
"SET NOCOUNT ON" within your stored procedure you can reduce some traffic.
You can still use
@@ROWCOUNT variable to get number of rows.
Share to Twitter
Share to Facebook
Share to Pinterest
Post a Comment
Post Comments (Atom)
How to install Windows Subsystem for Linux?
- Open Powershell in Admin mode and run wsl --install