本文介绍了在 SQL 输出中插入双引号的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着跟版网的小编来一起学习吧！
问题描述
例如，在我运行查询并查看输出之后
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?
推荐答案
如果您感兴趣的列不超过 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
这篇关于在 SQL 输出中插入双引号的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持跟版网！
本站部分内容来源互联网,如果有图片或者内容侵犯您的权益请联系我们删除！