SQLCMD adding a text qualifier

Question

How in the world do I add a text qualifier to an output result set in a csv file?

My code is as follows:

sqlcmd -S database_servername -i e:\sqldata\mysqlscript.sql -o\\shared_networkserver\directory\folder\subfolder\myoutput.CSV -s ","  -W




Now that works fine except I want my result set to look like this: "fieldresult1", "fieldresult2", "fieldresult3"

Basically have them in double qoutes and separated by a comma.

Thanks in advance

---

Network Analyst

Answer 1

You can add quotes in your query like this:

select '"' + isnull(column1,'') + '"', '"' + isnull(cast(column2 as varchar),'') + '"'
from t1

column2 is numeric datatype

With kind regards
Krystian Zieja
http://www.projectenvision.com

Answer 2

Kyrstian, thanks so much

That really helped me and that was the answer i was looking for

---

Network Analyst