Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

When I run a query in isql, I always get two lines returned: the return status and the affected row count. Can the return status line be suppressed in isql?

April 26, 2017affected isql query Return RETURNED row run Status

0

Posted

When I run a query in isql, I always get two lines returned: the return status and the affected row count. Can the return status line be suppressed in isql?

1 Answer

0

Posted

There is no option in isql at this time to suppress the return status line. SQL Server always returns status. Row count, on the other hand, can be suppressed if you wish by using the set nocount on command.