在 SQL 输出插入双引号
it1352
帮助4人
问题说明
例如，在我运行查询并查看输出之后
After I run a query and view the output, for example
select * from People
我的输出如下
First Last Email
Ray Smith raysmith@whatever.itis
如何导出这些数据，使其看起来如下所示?
How would I export this data so that it looks as follows?
"Ray","Smith","raysmith@whatever.itis"
或者有没有办法在 SQL 中执行此操作以修改记录以包含引号?
Or is there a way to do this within SQL to modify records to contain quotes?
因为当您导出时，它无论如何都会包含逗号，对吗?
Because when you export, it's going to include the commas anyway, right?
正确答案
#1
如果您感兴趣的列不超过 128 个字符，您可以使用 QUOTENAME 函数.请注意这一点，因为任何超过 128 个字符的内容都将返回 NULL.
If the columns you're interested in are 128 characters or less, you could use the QUOTENAME function. Be careful with this as anything over 128 characters will return NULL.
SELECT QUOTENAME(First, '"'), QUOTENAME(Last, '"'), QUOTENAME(Email, '"')
FROM People
这篇好文章是转载于：学新通技术网
