更新时间:2023-02-23 08:18:18
我怀疑您刚刚达到了 SSMS 中单个值的限制.
I suspect that you have just hit the limit for an individual value in SSMS.
令人讨厌的是,它不允许您将其设置为无限制,我所知道的显示长文本的唯一方法是通过转换为 XML,如下所示.
Annoyingly it doesn't allow you to set this to be unlimited and the only way I know of displaying long text is via casting to XML as below.
select
(select Replace(cast([Database].[dbo].[fruits].[Tekst] as NVARCHAR(MAX)),'bananas','apples') AS [processing-instruction(x)] FOR XML PATH(''), TYPE)
FROM [Database].[dbo].[fruits]