I frequently copy snippets of SQL code from a OneNote page and then paste into a server window or Notepad. The pasted text always contains an extra blank line above the next to last line.

OneNote source:

select table_name

from all_tables

where owner='MISC'

order by 1;

Notepad after paste:

---

select table_name
from all_tables
where owner='MISC'
<blank line after paste>
order by 1;

---

I tried to keep an extra blank line at the end of the source text, but the results are the same. Why does this happen and how can I stop it from pasting an extra line?

Thank you

Hi,

I can reproduce this issue in my OneNote 2013. I've researched for a long time and consulted some reference material, but still haven't found any clue regarding this issue. However, if I add an extra blank line (by pressing Enter or pressing the Down arrow key) at the end of the sorce text, it works around this issue. So, may I know which verison of OneNote you are using and how you add the extra blank line at the end?

Regards,

Steve Fan
TechNet Community Support