Possible Duplicate:
SET NOCOUNT ON usage
What is "NOCOUNT ON" in sql server, what it is do, where we can use it.
Asked
Active
Viewed 963 times
-4
Community
- 1
- 1
Surya sasidhar
- 28,627
- 55
- 134
- 215
-
[SET NOCOUNT](http://msdn.microsoft.com/en-us/library/ms189837.aspx) – Hans Olsson Oct 14 '11 at 09:36
1 Answers
4
It used to set ON/OFF the message that shows the count of the number of rows affected.
AksharRoop
- 2,208
- 1
- 18
- 29