BCP queryout question

Question

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Simon Sabin SSCrazy Eights Points: 8142 More actions · Answer 1

You need o use isql. or do something funky like add the column headers to the resultset i.e

select 'col1', 'col2', 'col3'

union all

select col1, col2, col3

from mytable

Simon Sabin

Co-author of SQL Server 2000 XML Distilled

dj_meier SSCrazy Points: 2732 More actions · Answer 2

I don't believe there is any parameter on bcp that will allow you to do that. Like Simon noted, you would have to do it manually.

-Dan

bsluman Say Hey Kid Points: 671 More actions · Answer 3

I semi cheated. I have the SP insert the column names in the top of the table before it exports.