Is there a switch that can be used with bcp to include the column names as
part of the resulting file from a queryout command ?

Thanks in advance

Use OSQL instead.


AMB

"David Franklin" wrote:

I am playing around with OSQL and I can't get it to work. Here is what I am
doing in bcp :

bcp "select * from database..view" queryout c:\test.csv -c -R -t "," -U
user -P password

I get everything I need except the column names. If you can get me pointed
in the right direction using OSQL, I would greatly appreciate it.

Thanks


"Alejandro Mesa" <AlejandroMesa (AT) discussions (DOT) microsoft.com> wrote

Example:

osql -S server_name -E -Q "select orderid, orderdate from dbo.orders" -d
northwind -s "," -o "c:\temp\test.txt"


AMB

"David Franklin" wrote:

I am so close, I have one more question - The file is being created, but the
results are wrapping over 2 lines. In bcp, each row of results took just
one line. I'm sure it's just a switch, but I can't figure it out...

"Alejandro Mesa" <AlejandroMesa (AT) discussions (DOT) microsoft.com> wrote

From books online:
Title: osql Utility

"-w column_width

Allows the user to set the screen width for output. The default is 80
characters. When an output line has reached its maximum screen width, it
is broken into multiple lines.
"

osql is a command line version of Query analyzer so it defaults to
wrapping the output after 80 characters so that you can see it on a
screen.

set the -w switch to 20000 or something else ridicuously large.



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

I ran into this problem just last night.

When I used osql the column headers showed, but it was riddled with the
padded spaces as well as the ----- between the headers and the data.

The solution that I found was to create a view on the fly. This view would
be two selects..

create view DataOutput as
select 'column1 header' as column1, 'column2 header' as column2
union all
select column1, column2 from table.

You may have to convert any #s to string values.

The next step would be to bcp the view.

bcp DataOutput out ........

Once I bcp'd the data, I went ahead and dropped the view. Worked like a
champ for me.

Pete

--
Message posted via http://www.sqlmonster.com