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 Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Can one suppress the "rows affected" line in a result

Status
Not open for further replies.
JaneMosk

JaneMosk

Programmer
Joined
Jul 2, 1999
Messages
7
Location
US
Is there a way to suppress the "rows affected" line in a select result?
 
Sort by date Sort by votes
You can use:<br>
<br>
set nocount on<br>
go<br>
<br>
before executing your query.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

AM_WG
  • Locked
  • Question Question
Need help with SQL query to update a Micros report
Replies
0
Views
865
AM_WG
AM_WG
cbsm
  • Locked
  • Question Question
select rows that are not locked
Replies
0
Views
523
cbsm
cbsm
DominoDerrik
  • Locked
  • Question Question
MICROS incrementing shifts
Replies
0
Views
500
DominoDerrik
DominoDerrik
raphael75
  • Locked
  • Question Question
installation errors on AWS Linux AMI
Replies
1
Views
621
raphael75
raphael75
yelizavetayr
  • Locked
  • Question Question
Sybase/Infomaker field dependency
Replies
0
Views
580
yelizavetayr
yelizavetayr

Part and Inventory Search

Sponsor

Back
Top