"bcp" question 
Author Message
 "bcp" question
I've written an SQL script which inserts some data into a table, then
outputs the data to a comma-delimted file using 'bcp'.   It works fine
except for one thing:

It doesn't include field/column names in the output.

I cannot see anything on the help page on including the field names.
Anyone got any idea how I can make it do this?

I am using SQL 6.5, so I cannot do a "BULK....." statement instead.

Thanks for any help
Owen


please copy reply via e-mail if possible - thanks.



Sun, 02 Jun 2002 03:00:00 GMT
 "bcp" question

As far as I know, it is not possible to have a header row.  Unless you do
it by hand.
Quote:

> I've written an SQL script which inserts some data into a table, then
> outputs the data to a comma-delimted file using 'bcp'.   It works fine
> except for one thing:

> It doesn't include field/column names in the output.

> I cannot see anything on the help page on including the field names.
> Anyone got any idea how I can make it do this?

> I am using SQL 6.5, so I cannot do a "BULK....." statement instead.

> Thanks for any help
> Owen


> please copy reply via e-mail if possible - thanks.



Sun, 02 Jun 2002 03:00:00 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. max of ("...","...","..")

2. How to make a "decimal"-field to an "integer"-field

3. "."and ","

4. "."and ","

5. The ""string""

6. aReport."Field".SetFilter("this")?

7. The+instruction+at+"0x1f90db9b"+referenced+memory+at+"0x7fa03794"+The+memory+cou

8. """ IT MAY SAVE YOUR LIFE""""

9. question on a "OCP reveiw question"

10. question on a "OCP reveiw question"

11. What is difference between "=", "=*", "*=" in where clause


 
Powered by phpBB® Forum Software