BCP out Column Headings

• jG

  SSCrazy

  Points: 2505

  More actions

  March 22, 2005 at 1:50 pm

  #163864

  Is there a way to bcp out the column headings simuliar to the way you can in the UI within DTS?

  
  -JG

• Frank Kalis

  SSC Guru

  Points: 111183

  More actions

  March 23, 2005 at 1:40 am

  #548395

  I'm not aware of anything simpler, but this should work:

  if object_id('workaround')>0

   drop view Workaround

  use pubs

  go

  create view Workaround as

  select

   au_id

   , au_lname

   , au_fname

   , phone

   , address

   , city

   , state

   , zip

   , convert(char, contract) 'contract'

   , 1 as SeqNo from authors

  union

  select

   'au_id'

   , 'au_lname'

   , 'au_fname'

   , 'phone'

   , 'address'

   , 'city'

   , 'state'

   , 'zip'

   , 'contract'

   , 0 as SeqNo

  go

  exec master..xp_cmdshell

   'bcp "select au_id, au_lname, au_fname, phone, address, city, state, zip,contract from pubs..Workaround order by SeqNo, au_id" queryout "C:\authors.txt"  -c  -T -SyourServer'

  --
  Frank Kalis
  Microsoft SQL Server MVP
  Webmaster: http://www.insidesql.org/blogs
  My blog: http://www.insidesql.org/blogs/frankkalis/[/url]