|
How to remove row affected and dashes
Sybase Interview Questions and Answers
(Continued from previous question...)
How to remove row affected and dashes
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.
(Continued on next question...)
Other Interview Questions
| 