SET NOCOUNT ON

SET NOCOUNT ON

By default when you create stored procedure SQL Serer the SET NOCOUNT is ON.
In SQL server if you Set the NOCOUNT ON, you will not get count of number of rows affected by
Insert or Update or Delete queries.
When you set the NOCOUNT to OFF, your client application will get the count of number of rows affected
during the operations like Insert or Update or Delete.

image

How does it affect the performance?

The @@ROWCOUNT still updates even if you SET NOCOUNT ON. It only prevents sending of the message to client
about affected row number and it reduces the size of message (Reduces network traffic).

Yahoo email settingsChange Firefox Proxy SettingsHow to set default browserGodaddy email configuration settingsGoogle – Search settingsJQuery set .focus()JQuery access label control and set valueA-nested-transaction-was-required-because-the-XACT_ABORT-option-was-set-to-OFFJQuery Set Value of Textbox or Label Control In Asp.netJquery Set Value Of Textbox.This command requires an asynchronous connection Set Asynchronous Processing3dtrue in the connection string

Author

My name is Satalaj, but people call me Sat. Here is my homepage: . I live in Pune, PN and work as a Software Engineer. I'm former MVP in ASP.net year 2010.
Disclaimer: Views or opinion expressed here are my personal research and it has nothing to do with my employer. You are free to use the code, ideas/hints in your projects. However, you should not copy and paste my original content to other web sites. Feel free to copy or extend the code.
If you want to fight with me, this website is not for you.
 

I'm Satalaj.