How to remove row affected and dashes?
Submitted by: AdministratorIf 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
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
Read Online Sybase Job Interview Questions And Answers
Top Sybase Questions
| ☺ | What is a Coalesce? What is the equivalent of Oracle/Db2 Coalesce Function in Sybase? |
| ☺ | How to pad with leading zeros an int or smallint in Sybase? |
| ☺ | Explain about the features of Sybase IQ? |
| ☺ | How can I execute dynamic SQL with ASE in Sybase? |
| ☺ | Explain about Power Designer Data modeling software? |
Top Databases Programming Categories
| ☺ | RDBMS Interview Questions. |
| ☺ | SQL Interview Questions. |
| ☺ | SSRS Interview Questions. |
| ☺ | Database Administrator (DBA) Interview Questions. |
| ☺ | Sybase Interview Questions. |
