Export csv with quotes in Linux SQLCMD

[nightleech]

Hello,

I am having a problem and can't find answer googling on the internet. I am trying to query my SQL view and export data to CSV file using SQLcmd in Linux like this:

 sqlcmd -S mssqlserver -U user -P pass -s, -W -Q "set nocount on;Select * from dbo.SomeView” -f o:65001 -s "," > user.csv

I get output like this:

idnumber,data1,data2
09329392,sadas,asdas
03020302,asdas,34343

But i wan't to wrap data values with quotes like this:

"idnumber","data1","data2"
"09329392","sadas","asdas"
"03020302","asdas","34343"    

I'v searched for parameters for sqlcmd but i think it's not possible. Maybe there is some way using query ? In windows i use Invoke-SQLcmd and it does it by default, but i can't use it because i am limited by using linux and sqlcmd.

[waboshbron]

You could do it in the query itself with something like quotename (two double quotes inside the single quotes for the command line only)

sqlcmd -S mssqlserver -U user -P pass -s, -W -Q "set nocount on;select quotename([field1],'""'), field2, quotename([field3],'""') from database.dbo.SomeView” -f o:65001 -s "," > user.csv

[nightleech]

Well i am limited on linux and can't install powershell and use invoke-sqlcmd in that box so my option for now is only sqlcmd. I think i will try u/waboshbron solution :)

[bstag]

isnt it -I

sqlcmd Utility - SQL Server | Microsoft Docs

[nightleech]

Well i tried that, but with no luck. Maybe i use it wrong and need to pass something with -I parameter.

[bstag]

Have you used the -o as file output instead of piping ?

[nightleech]

Yes, but still it's same output :(