Sybase Interview Question:

How to remove row affected and dashes?

Submitted by: Administrator

If you pipe the output of isql then you can use sed(1) to remove this extraneous output:

echo "$PASSWD
sp_who
go" | isql -U sa -S MY_SERVER | sed -e '/affected/d'
-e '/---/d'


If you simply wish to eliminate the row affected line use the set nocount on switch.
Submitted by: Administrator