blocks|key|3321151|text|将文本从SSMS复制到Microsoft+word。然后将格式化文本从MS+Word复制到OneNote。工作正常。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3321152|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|$]]

Copy the text from SSMS to Microsoft word. Then copy the formatted text from MS Word to OneNote. Works fine.

blocks|key|2276204|text|这是MS+Office“有用的”“智能引号”和类似格式的结果。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2276205|2276206|如果可能，请在OneNote|ordered-list-item|2276207|Copy+|2276208|+OneNote中关闭智能引号等功能，粘贴到纯文本编辑器中，然后从那里复制并粘贴到SSMS中。您可能仍会收到一些无效字符。|2276209|2276210|归根结底，像Word和OneNote这样的程序对于需要特定字符的技术性内容通常会适得其反，因为它们是为非技术性写作而设计的。您可能希望考虑切换到另一个note组织工具，该工具不会像这样搞乱格式。|2276211|entityMap^0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|O|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|P|8|@]|9|@]|A|$]]|$1|C|3|D|5|E|7|Q|8|@]|9|@]|A|$]]|$1|F|3|G|5|E|7|R|8|@]|9|@]|A|$]]|$1|H|3|I|5|E|7|S|8|@]|9|@]|A|$]]|$1|J|3|-4|5|6|7|T|8|@]|9|@]|A|$]]|$1|K|3|L|5|6|7|U|8|@]|9|@]|A|$]]|$1|M|3|-4|5|6|7|V|8|@]|9|@]|A|$]]]|N|$]]

This is the result of MS Office's "helpful" "smart quotes" and similar formatting.

<ol>
<li>If possible turn off smart quotes and the like in OneNote</li>
<li>Copy from OneNote, paste into a plain-text editor, then copy from there &amp; paste into SSMS. You may still get some invalid characters.</li>
</ol>

What it really boils down to is that programs like Word and OneNote are often counter-productive for technical content that requires specific characters because they are designed for non-technical writing. You may wish to consider switching to another note organizational tool that doesn't muck with formatting like this.

blocks|key|5433051|text|我也有同样的问题，我使用的是NoteHighlight，但我不是在ON2013中工作。我现在使用OneNote宝石，但正如其他人指出的那样，它不是免费的，但很便宜，28美元。您可以突出显示SSMS中的查询，复制，然后选择单击GEM编辑菜单中的“粘贴富文本”，它将保留包含颜色的格式，要将其粘贴回SSMS中而不包含无法识别的字符，请突出显示OneNote中的文本，然后形成“生成编辑”菜单单击“复制纯文本”并粘贴回SSMS|type|unstyled|depth|inlineStyleRanges|entityRanges|data|5433052|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|$]]

I was having the same issue and I was using NoteHighlight but I does not work in ON2013. I now use OneNote Gem but as someone else pointed out it is not free but inexpensive $28.00 US. You can highlight the the queries in SSMS, copy and then select Click on "Paste Rich Text" in the GEM Edit menu and it will keep the formatting including the color, to paste it back into SSMS without the unrecognized characters, highlight the text in OneNote then form the GEN Edit Menu Click on "Copy Plain Text" and paste back into SSMS

blocks|key|3320885|text|我不能帮助粘贴到SSMS中，但是您有几个语法突出显示的选项：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3320886|3320887|This+add-in不适用于我，但我使用的是2013年的64位，也许它可以在32位或2010年运行，显然它对一些人有效，在past.|ordered-list-item|offset|length|3320888|OneNote+Gem中有一个语法高亮选项。我发现他们的用户界面有点乱，不得不粘贴到一个特殊的窗口中很烦人，但它确实可以工作。|3320889|3320890|entityMap|0|LINK|mutability|MUTABLE|url|http://notehighlight.codeplex.com/|1|http://www.onenotegem.com/gem-for-onenote-2010.html^0|0|0|0|B|0|0|0|B|1|0|0^^$0|@$1|2|3|4|5|6|7|U|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|V|8|@]|9|@]|A|$]]|$1|C|3|D|5|E|7|W|8|@]|9|@$F|X|G|Y|1|Z]]|A|$]]|$1|H|3|I|5|E|7|10|8|@]|9|@$F|11|G|12|1|13]]|A|$]]|$1|J|3|-4|5|6|7|14|8|@]|9|@]|A|$]]|$1|K|3|-4|5|6|7|15|8|@]|9|@]|A|$]]]|L|$M|$5|N|O|P|A|$Q|R]]|S|$5|N|O|P|A|$Q|T]]]]

I can't help on pasting into SSMS but you have a couple of options for the syntax highlighting:

<ol>
<li><a href="http://notehighlight.codeplex.com/" rel="nofollow">This add-in</a> doesn't work for me, but I have ON 2013 64bit, maybe it'll work in 32bit or 2010, clearly it has worked for some people in the past.</li>
<li><a href="http://www.onenotegem.com/gem-for-onenote-2010.html" rel="nofollow">OneNote Gem</a> has a syntax highlight option. I find their UI a bit cluttered and it is annoying to have to paste into a special window, but it does work.</li>
</ol>

blocks|key|5432921|text|对于SSMS到OneNote的问题，我知道这个答案实际上只是您的Word变通方法的一个变体，但我在复制到OneNote之前会在Visual+Studio中打开SQL文件。通过这种方式，格式也可以被复制。如果你可以在你的工作流程中考虑到这一点，那么我认为这是一个比Word更好的变通办法，因为你当然也可以在VS中编辑文件。请注意，您将需要VS+Productivity+Power+Tools插件来实现格式复制。例如，对于VS2013，请转到：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|5432922|5432923|https://visualstudiogallery.msdn.microsoft.com/dbcb8670-889e-4a54-a226-a48a15e4cace?SRC=Home|unordered-list-item|offset|length|5432924|5432925|entityMap|0|LINK|mutability|MUTABLE|url^0|0|0|0|2K|0|0|0^^$0|@$1|2|3|4|5|6|7|P|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]|$1|C|3|D|5|E|7|R|8|@]|9|@$F|S|G|T|1|U]]|A|$]]|$1|H|3|-4|5|6|7|V|8|@]|9|@]|A|$]]|$1|I|3|-4|5|6|7|W|8|@]|9|@]|A|$]]]|J|$K|$5|L|M|N|A|$O|D]]]]

For the SSMS to OneNote issue, I know this answer is really only a variant of your Word workaround, but I open up SQL files in Visual Studio prior to copying into OneNote. In that way the format can be copied too. If you can consider that in your workflow then I think it's a better workaround than Word, as of course you can also edit the files in VS.
Note that you'll need the VS Productivity Power Tools plug-in to achieve the format copy. e.g. for VS2013 go to:

<ul>
<li><a href="https://visualstudiogallery.msdn.microsoft.com/dbcb8670-889e-4a54-a226-a48a15e4cace?SRC=Home" rel="nofollow">https://visualstudiogallery.msdn.microsoft.com/dbcb8670-889e-4a54-a226-a48a15e4cace?SRC=Home</a></li>
</ul>

blocks|key|2279944|text|一种可能的解决方法是在web客户端中打开笔记本，然后从SSMS粘贴到onenote+web应用程序。这是直接工作的|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2279945|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|$]]

A possible workaround is to open the notebook in the web client and paste from SSMS to the onenote web app. That works directly

blocks|key|5433229|text|我为这个问题写了这个小插件。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|5433230|https://github.com/SamuelOConnor/RichPaste|offset|length|5433231|entityMap|0|LINK|mutability|MUTABLE|url^0|0|0|16|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|N|8|@]|9|@$D|O|E|P|1|Q]]|A|$]]|$1|F|3|-4|5|6|7|R|8|@]|9|@]|A|$]]]|G|$H|$5|I|J|K|A|$L|C]]]]

I wrote this little addin for this exact issue

<a href="https://github.com/SamuelOConnor/RichPaste" rel="nofollow noreferrer">https://github.com/SamuelOConnor/RichPaste</a>

I use OneNote to keep all usefull info for my work, including SQL queries.

So I copy paste them between OneNote and Microsoft SSMS (SQL Server Management Studio)

When I do so, I have often wrong characters in SSMS that I must remove manually.

In the other way around (from SSMS to OneNote), the nice color SQL formatting is lost (I can put it into MS Word and then OneNote and it works but it is not very practical).

Copy paste SQL between MS OneNote and SSMS

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋 

腾讯云代码助手

CODING DevOps

Cloud Studio

SDK中心

API中心

命令行工具

我使用OneNote来保存我工作中所有有用的信息，包括SQL查询。所以我在OneNote和Microsoft SSMS (SQL Server Management Studio)之间复制粘贴它们。当我这样做时，我经常在SSMS中有错误的字符，我必须手动删除。另一方面(从SSMS到OneNote)，漂亮的彩色SQL格式丢失了(我可以把它放到MS Word中，然后放到OneNote中，它可以工作，但

问在MS OneNote和SSMS之间复制粘贴SQL
EN

回答 7

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问在MS OneNote和SSMS之间复制粘贴SQLEN

回答 7

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问在MS OneNote和SSMS之间复制粘贴SQL
EN