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 SkipVought 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
Jun 19, 2001
29
0
0
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
works like a dream - great cheers
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

TheBugSlayer
  • Locked
  • Question
How to make xp_cmdshell use SQL Server's bcp utility instead of Sysbase's 1
Replies
7
Views
199
Nick_Evans1
Nick_Evans1
R7Dave
  • Locked
  • Question
SQL 2005 utility
Replies
2
Views
18
mrdenny
mrdenny
egodette
  • Locked
  • Question
ISQL command line
Replies
8
Views
29
earthandfire
earthandfire
ptheriault
  • Locked
  • Question
tablediff utility
Replies
0
Views
5
ptheriault
ptheriault
maltu
  • Locked
  • Question
isql execution error message
Replies
0
Views
9
maltu
maltu

Part and Inventory Search

Sponsor

Back
Top