Overcome BCP limitations for output to CSV file

• David A. Long

  SSCrazy Eights

  Points: 8421

  More actions

  September 24, 2007 at 2:28 am

  #178763

  Comments posted to this topic are about the item Overcome BCP limitations for output to CSV file

• call_gangadhar

  Grasshopper

  Points: 11

  More actions

  February 14, 2008 at 11:08 pm

  #778723

  David A. Long (9/24/2007)

  ---

  Comments posted to this topic are about the item

  Here is an easier method to get headers in output file

  bcp "(Select 'PIN','Name') UNION ALL (Select Convert(Varchar,PIN),FName From GangadharG.dbo.CustInfo)" queryout out.txt -U sa -P welcome -c -t "|"

  -GGSanthosh