更新时间:2022-05-03 22:18:11
如果我运行 sp_helptext
并设置 Results to grid
,我可以复制此行为,然后复制并粘贴将网格中的结果放入新查询或任何其他文本编辑器中.
I can replicate this behaviour if I run sp_helptext
with Results to grid
set, then copy and paste the results from grid into a new query or any other text editor.
这似乎是 sp_helptext
与以前版本相比的行为发生了变化,因为标准网格结果集不显示此效果.
This seems to be a change in the behaviour of sp_helptext
from previous editions, since this effect isn't displayed with standard grid result sets.
最简单的解决方法是运行 sp_helptext
并设置 Results to text
(Query
-> Results to
> 结果转文本
,快捷键CTRL
+ T
.
The simplest work-around will be to run sp_helptext
with Results to text
set (Query
-> Results to
> Results to text
, shortcut CTRL
+ T
.
您可能需要增加 Results to text
中每行的最大字符数以获得您期望的输出 - Tools
> Options
> 查询结果
> Results to text
- 设置每列显示的最大字符数"为最大值8192.
You may need to increase the maximum number of characters per line in Results to text
to get the output you expect - Tools
> Options
> Query Results
> Results to text
- set "maximum number of characters displayed in each column" to the maximum value of 8192.