bcp statement written on multiple lines

• texpic

  SSCertifiable

  Points: 5885

  More actions

  September 15, 2006 at 8:58 am

  #172496

  This works:

  exec master..xp_cmdshell

  'bcp "SELECT * FROM CsvData..UserStats" queryout c:\test.csv  /t "\",""  -c'

  If I try to put the statement on multiple lines, it does not work (tried + signs and &amp

  exec master..xp_cmdshell

  'bcp "SELECT * FROM CsvData..UserStats"

  queryout c:\test.csv

  /t "\",""  -c'

• Chris Chilvers

  SSCrazy

  Points: 2260

  More actions

  September 15, 2006 at 5:45 pm

  #660847

  It looks like xp_cmdshell only uses the first line as the command to run.

  I tried running a command using ^ (needed in the command prompt to split a command over multiple lines) and I still got nothing.

  It does work if you concatenate it as one line in a local variable first, then call xp_cmdshell with the local variable.