Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SET NOCOUNT OFF?

Status
Not open for further replies.
KCWMS

KCWMS

MIS
Mar 25, 2004
38
US
I have noticed that nobody uses SET NOCOUNT OFF after turning it on.. even the VS SP Template does not include it.

Why not?
 
Sort by date Sort by votes
It is a session based setting. Once you close the setting it is back on for the next session. There is no need to turn it back on, unless you specifically neede the output from part of your query.

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

[noevil]
(Not quite so old any more.)
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

jimoo
  • Locked
  • Question
How to set variable to field in current row
Replies
2
Views
764
Chris Miller
Chris Miller
carolx
  • Locked
  • Question
How to get the result set from the table using a query. Enter to see the table and result set.
Replies
3
Views
54
TamarGranor
TamarGranor
wbodger
  • Locked
  • Question
Find consecutive numbers 3 or more within a set
Replies
3
Views
78
gmmastros
gmmastros
DougP
  • Locked
  • Question
SQL server set variable equal to result from concatenated string
Replies
3
Views
88
Olaf Doschke
Olaf Doschke
bmacbmac
  • Locked
  • Question
How to set a variable - perform an action - and then set the variable to + 1
Replies
2
Views
62
DaveInIowa
DaveInIowa

Part and Inventory Search

Sponsor

Back
Top