BCP: How to Display Column Headers

• spkel

  Valued Member

  Points: 54

  More actions

  August 14, 2003 at 9:35 am

  #83043

  HI,

  I'm using the following bcp command to generate a text file. How do I include the column headers as the first row. THANKS

  bcp "SELECT Basix_IM01.dbo.dc_flat_file.* FROM Basix_IM01.dbo.dc_flat_file WHERE ([DC Number] = 6)" queryout "NIN_06_081403.txt" -F 1 -c -t "|"

• dj_meier

  SSCrazy

  Points: 2732

  More actions

  August 14, 2003 at 4:20 pm

  #470030

  It's not really possible, unless you right a query that looks at syscolumns, and uses a UNION to pre-pend it to the beginning of the result set.

  -Dan

  
  -Dan

• dj_meier

  SSCrazy

  Points: 2732

  More actions

  August 14, 2003 at 4:21 pm

  #470031

  BTW...you can use DTS to do that easily.

  -Dan

  
  -Dan