0 votes
10 views
What is the use of SET NOCOUNT ON/OFF statement?
in Technology by (51.6k points)

1 Answer

0 votes

What is the use of SET NOCOUNT ON/OFF statement?

By default, NOCOUNT is set to OFF and it returns number of records got affected whenever the command is getting executed. If the user doesn't want to display the number of records affected, it can be explicitly set to ON- (SET NOCOUNT ON).

by (51.6k points)

Related questions

0 votes
1 answer 14 views
0 votes
1 answer 11 views
0 votes
1 answer 5 views
0 votes
1 answer 27 views
0 votes
1 answer 22 views
0 votes
1 answer 17 views
0 votes
1 answer 18 views
0 votes
1 answer 15 views
0 votes
1 answer 23 views
0 votes
1 answer 25 views
0 votes
1 answer 18 views
18 views asked Jan 11 in Technology by JackTerrance (190k points)
0 votes
1 answer 27 views
0 votes
1 answer 19 views
...