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!

isql Utility

Status
Not open for further replies.
GRHE

GRHE

Programmer
Joined
Jun 19, 2001
Messages
29
Location
GB
HI

Is there an argument to stop it displaying (213 rows affected) ???

Cheers
 
Sort by date Sort by votes
run the following command at the start of the query

set nocount on

note this command is 'sticky' which means it lasts for the session
 
Upvote 0 Downvote
Add this to the top of your SQL batch...
set nocount on
 
Upvote 0 Downvote
works like a dream - great cheers
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

TheBugSlayer
  • Locked
  • Question Question
How to make xp_cmdshell use SQL Server's bcp utility instead of Sysbase's
Replies
7
Views
2K
Nick_Evans1
Nick_Evans1
R7Dave
  • Locked
  • Question Question
SQL 2005 utility
Replies
2
Views
123
mrdenny
mrdenny
egodette
  • Locked
  • Question Question
ISQL command line
Replies
8
Views
245
earthandfire
earthandfire
ptheriault
  • Locked
  • Question Question
tablediff utility
Replies
0
Views
54
ptheriault
ptheriault
maltu
  • Locked
  • Question Question
isql execution error message
Replies
0
Views
105
maltu
maltu

Part and Inventory Search

Sponsor

Back
Top