Overcome BCP limitations for output to CSV file

• David A. Long

  Newbie

  Points: 0

  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

  Newbie

  Points: 0

  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