sql-server - 当前命令发生严重错误。 - 未知错误

Question

这是我的代码。

;With CTE as
(
select
    a.rn,
    a.LongDescription as ad,
    b.LongDescription as bd
from myTabl as a
    left join myTabl as b on a.rn +1 = b.rn
where
    a.rn=1
and
    a.LongDescription = 'Eric'
)
update CTE
    set ad += ' ' + b.LongDescription
from CTE as a
    left join myTabl as b on a.rn = b.rn+1
where
    a.rn=1

我试图回答一个问题，同时尝试差异。我遇到以下错误的选项，

Msg 0, Level 11, State 0, Line 0
A severe error occurred on the current command.  The results, if any, should be discarded.
Msg 0, Level 20, State 0, Line 0
A severe error occurred on the current command.  The results, if any, should be discarded.

这是什么，我什么都没有。我的代码有什么重大错误吗？我试图用谷歌搜索它，但所有结果都将我重定向到“Microsoft Fix”。有些人可以用简单的话解释我有什么问题吗？

Answer 1

我想您需要更改设置行:

set ad = a.ad + ' ' + b.LongDescription

查看 SQL fiddle 演示 here