No Double Quote at start of BCP'd file

[jeffwest21]

I have an export that is ouputtying some data from SQL using bcp, I need to add quotes around it but everytime it output i miss a double quote at the start and get and extra one at the end.

I am using this

select @sql = 'bcp "select * from Database.dbo.table " queryout '+ @file +'  /c -t \",\" -r \n\" -T -S' + @@servername

Can anyone see what I am missing to get this working?

'Clever boy...'

 

[simian336]

Show us what you want your final output to be and we can show you how to fix it.

Simi

 

[simian336]

Show us what you want your final output to be and we can show you how to fix it.

Simi

 

[jeffwest21]

This is what I am getting

00008016","30/09/2013 16:31","30/09/2013 16:31
"

This is what I would like

"00008016","30/09/2013 16:31","30/09/2013 16:31"

'Clever boy...'

 

[philhege]

Late to this party, but you have to use a format file to qualify the text output with quotes. Or you could write a view that stuffs the quote mark in the results.

-----------
With business clients like mine, you'd be better off herding cats.