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 985 times
-4
Community
- 1
- 1
Surya sasidhar
- 29,607
- 57
- 139
- 219
-
[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,263
- 1
- 19
- 29