I have the following query, but I am receiving this error:
我有以下查询,但我收到此错误:
Only one expression can be specified in the select list when the subquery is not introduced with EXISTS.
当未使用EXISTS引入子查询时,只能在选择列表中指定一个表达式。
(select replace((stuff (itemdata,1,66,'')), '<BodyText>', '')as text
from charts
where itemtype = 'DocumentItems_RichText' and checksum ='1'
union all
select stuff (itemdata,1,66,'')
from charts
where itemtype = 'DocumentItems_RichText'
and checksum <>'1' )AS Content
1 个解决方案
#1
0
You can try this:
你可以试试这个:
SELECT Content
FROM
(
select replace((stuff (itemdata,1,66,'')), '<BodyText>', '')as text
from charts
where itemtype = 'DocumentItems_RichText'
and checksum ='1'
union all
select stuff (itemdata,1,66,'')
from charts
where itemtype = 'DocumentItems_RichText'
and checksum <>'1'
) DS (Content);
#1
0
You can try this:
你可以试试这个:
SELECT Content
FROM
(
select replace((stuff (itemdata,1,66,'')), '<BodyText>', '')as text
from charts
where itemtype = 'DocumentItems_RichText'
and checksum ='1'
union all
select stuff (itemdata,1,66,'')
from charts
where itemtype = 'DocumentItems_RichText'
and checksum <>'1'
) DS (Content);