Posted by Stu on 10/05/06 03:46

The easiest way that I know how to do this is to change the output
format in query analyzer. Look under Tools, Options, Results, Results
Output Format and see if one of the format options will meet your
needs. You can issue the SQL command SET NOCOUNT ON; to eliminate the
rows affected message.

Stu


Daniel.Peaper@gmail.com wrote:
> Hi folks,
>
> I'm trying to write a simple SELECT statement that will execute in
> query analyser but will just have the data with no column names, or the
> dotted line between them and the data. I also want to avoid the
> statement at the end which says nnn rows affected. any ideas? I want to
> do this because I intend to write the results to a flat file.
>
> Thanks for your help
> Danny....

• Next in forum: Artificial Mind - Part One - Basic Architecture and Cognitive Structure is now available
• Prev in forum: How to retrieve query results with now field names, dotted line or footer
• Thread view: Re: How to retrieve query results with now field names, dotted line or footer

[Reply to this message]