Hi
There could be a cludge!
Use -h-1 or remove the print headers and do a union. That forces the column
headers as the first row retrieved. You will need a method to sort the
results which probably makes it as bad as having the underlines themselves!
select 'pub_id' as pub_id, 'pub_name' as pub_name, 0 as ' '
union all
select CONVERT(varchar,pub_id), pub_name, 1 from publishers
order by 3
John
"John Bell" <jb************@hotmail.com> wrote in message
news:3f*********************@reading.news.pipex.ne t...
Hi
I don't think there is a way to stop the dashed lines, although you could
send the output to a file and strip it out with findstr. To get rid of the
column headers (and lines) remove the check box for "print headers" in
tools/options/results or specify -h-1 when using isql or osql.
John
"." <se******@subdimension.com> wrote in message
news:24**************************@posting.google.c om... Hi All !
Is it possible to get rid of these dash symbols which are underlining
the column name when recordset is returned after query execution ?
For example, using isql.exe:
SELECT 'blah'
go
produces the following results:
----
blah
What I want to achieve is just
blah
I know that SET NOCOUNT ON switches the "X row affected" thing. But
how about column headers ?
Thanks for your time,
Seeker