SQl 输出到 CSV(不带单引号)

Question

我正在 Adaptive Server Anywhere v7 上运行查询。

select customerinfo.customerid, Name, Address1, Address2, City, State, ZIP, Country from customerinfo, addressinfo
where customerinfo.customerid = addressinfo.customerid
and MEMBER = (Date(GetDate()-4))
and addressinfo.addresstype = 's';
Output to C:\SamplePacks.CSV

输出是:

123, '姓名','地址1,'地址2'......

有没有办法运行查询以使单引号不显示？

Answer 1

参见doc

QUOTE clause The QUOTE clause is for the TEXT output format only. The quote string is placed around string values. The default is a single quote ('). If ALL is specified in the QUOTE clause, the quote string is placed around all values, not just around strings. To suppress quoting, specify empty single quotes. For example, QUOTE ''.

看来你应该这样做

Output to 'C:\SamplePacks.CSV' QUOTE ''