在 SQL 输出中插入双引号

2021-09-10 00:00:00 sql tsql sql-server-2008 sql-server

例如，在我运行查询并查看输出之后

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

相关文章