blocks|key|875927|text|如果您感兴趣的列不超过128个字符，则可以使用QUOTENAME函数。注意这一点，因为任何超过128个字符的内容都将返回NULL。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|875928|SELECT+QUOTENAME(First,+'"'),+QUOTENAME(Last,+'"'),+QUOTENAME(Email,+'"')
++++FROM+People|code-block|syntax|javascript|875929|entityMap|0|LINK|mutability|MUTABLE|url|http://msdn.microsoft.com/en-us/library/ms176114.aspx^0|1O|4|N|9|0|0|0^^$0|@$1|2|3|4|5|6|7|S|8|@$9|T|A|U|B|C]]|D|@$9|V|A|W|1|X]]|E|$]]|$1|F|3|G|5|H|7|Y|8|@]|D|@]|E|$I|J]]|$1|K|3|-4|5|6|7|Z|8|@]|D|@]|E|$]]]|L|$M|$5|N|O|P|E|$Q|R]]]]

If the columns you're interested in are 128 characters or less, you could use the <a href="http://msdn.microsoft.com/en-us/library/ms176114.aspx">QUOTENAME</a> function. Be careful with this as anything over 128 characters will return <code>NULL</code>.

<pre><code>SELECT QUOTENAME(First, '"'), QUOTENAME(Last, '"'), QUOTENAME(Email, '"')
 FROM People
</code></pre>

blocks|key|658729|text|选择concat(“\”“，first，”\“”，“\”“，Last，”\“”，“\”，Email，“\”)作为allInOne|type|unstyled|depth|inlineStyleRanges|entityRanges|data|658730|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

select concat(“\"”,first,“\"”,“\"”,Last,“\"”,“\"”,Email,“\"”) as allInOne

blocks|key|658782|text|修改记录以包含引号将是一场灾难；您不能仅将数据用于导出。此外，从理论上讲，您必须处理以下名称：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|658783|+Thomas+"The+Alley+Cat"+O'Malley|code-block|syntax|javascript|658784|这就带来了一些问题。|658785|在标准SQL中，您可以使用双引号将单引号括起来(对于双引号没有特殊处理)：|658786|'"Thomas+"The+Alley+Cat"+O''Malley"'|658787|某些DBMS允许您在字符串两边使用双引号(在标准SQL中，双引号表示“分隔标识符”；SQL+Server为此使用方括号)，在这种情况下，您可以将字符串写为：|658788|"""Thomas+""The+Alley+Cat""+O'Malley"""|658789|不过，通常情况下，您的导出器工具会提供CSV输出格式化，而您的SQL语句不需要担心这一点。嵌入的引号会让其他任何事情变得有问题。实际上，您通常不应该让DBMS处理数据的格式化。|658790|entityMap^0|0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|U|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|V|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|W|8|@]|9|@]|A|$]]|$1|I|3|J|5|6|7|X|8|@]|9|@]|A|$]]|$1|K|3|L|5|D|7|Y|8|@]|9|@]|A|$E|F]]|$1|M|3|N|5|6|7|Z|8|@]|9|@]|A|$]]|$1|O|3|P|5|D|7|10|8|@]|9|@]|A|$E|F]]|$1|Q|3|R|5|6|7|11|8|@]|9|@]|A|$]]|$1|S|3|-4|5|6|7|12|8|@]|9|@]|A|$]]]|T|$]]

Modifying the records to contain quotes would be a disaster; you don't use the data only for export. Further, in theory you'd have to deal with names like:

<pre><code> Thomas "The Alley Cat" O'Malley
</code></pre>

which presents some problems.

In Standard SQL, you'd use doubled-up single quotes to enclose single quotes (with no special treatment for double quotes):

<pre><code>'"Thomas "The Alley Cat" O''Malley"'
</code></pre>

Some DBMS allow you to use double quotes around strings (in Standard SQL, the double quotes indicate a 'delimited identifier'; SQL Server uses square brackets for that), in which case you might write the string as:

<pre><code>"""Thomas ""The Alley Cat"" O'Malley"""
</code></pre>

Normally, though, your exporter tools provide CSV output formatting and your SQL statement does not need to worry about it. Embedded quotes make anything else problematic. Indeed, you should usually not make the DBMS deal with the formatting of the data.

blocks|key|658803|text|这对我来说效果最好|type|unstyled|depth|inlineStyleRanges|entityRanges|data|658804|SELECT+'UPDATE+[dbo].[DirTree1]+SET+FLD2UPDATE=',QUOTENAME(FLD2UPDATE,'''')
%2B'+WHERE+KEYFLD='%2BQUOTENAME(KEYFLD,'''')
FROM+[dbo].[Table1]
WHERE+SUBSTRING(FLD2UPDATE,1,2)+=+'MX'
order+by+2|code-block|syntax|javascript|658805|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

This worked best for me

<pre><code>SELECT 'UPDATE [dbo].[DirTree1] SET FLD2UPDATE=',QUOTENAME(FLD2UPDATE,'''')
+' WHERE KEYFLD='+QUOTENAME(KEYFLD,'''')
FROM [dbo].[Table1]
WHERE SUBSTRING(FLD2UPDATE,1,2) = 'MX'
order by 2
</code></pre>

blocks|key|876061|text|如果您使用的是MS+SQL+Server，请尝试执行以下操作：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|876062|SELECT+'"'%7C%7CTable.Column%7C%7C'"'
++FROM+Table|code-block|syntax|javascript|876063|--请注意，"SELECT“和"%7C%7C”之间的前3个字符是：‘“’|876064|--末尾"%7C%7C“后的字符相同...这样，你的价值的每一面都会有一个“。|876065|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|N|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|O|8|@]|9|@]|A|$]]|$1|I|3|J|5|6|7|P|8|@]|9|@]|A|$]]|$1|K|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|L|$]]

If you are using MS SQL Server, try something like:

<pre><code>SELECT '"'||Table.Column||'"'
 FROM Table
</code></pre>

-- Note that the first 3 characters between "SELECT" and "||" are:
' " ' 

-- The characters are the same after "||" at the end... that way you get a " on each side of your value.

After I run a query and view the output, for example

<code>select * from People</code>

My output is as follows

<pre><code>First Last Email
Ray Smith raysmith@whatever.itis
</code></pre>

How would I export this data so that it looks as follows?

<pre><code>"Ray","Smith","raysmith@whatever.itis"
</code></pre>

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?

Insert double quotes into SQL output

SQL Server

在我运行查询并查看输出之后，例如select * from People我的输出如下First   Last      EmailRay     Smith     raysmith@whatever.itis我如何导出这些数据，使其看起来如下所示？"Ray","Smith","raysmith@whatever.it...

问在SQL输出中插入双引号
EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问在SQL输出中插入双引号EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问在SQL输出中插入双引号
EN