使用sql xml路径时出现问题 [英] Problem using sql xml path

问题描述

我想连接一个列值。所以我给出了以下内容，但它不能正常显示错误。

I want to concatenate one column values. So I give following, But it is not working the error displays.

SELECT STUFF((SELECT ',' + scd_service_id FROM Service_Details FOR XML PATH(")),1,2,")

错误是

The error is

Msg 102, Level 15, State 1, Line 1
Incorrect syntax near '')),1,2,''.

推荐答案

看来你用了双引号 而不是两个单个qoutes''''。检查用新查询更新您的查询，如下所示

It seems you have used double quote" instead of two single qoutes''''. check updating your query with new query as shown below

your query :
SELECT STUFF((SELECT ',' + scd_service_id FROM Service_Details FOR XML PATH(")),1,2,")

new query :
SELECT STUFF((SELECT ',' + scd_service_id FROM Service_Details FOR XML PATH('')),1,2,'')

如下所示进行投射。

Do casting as shown below.

new query :
SELECT STUFF((SELECT ',' + ltrim(cast(scd_service_id as varchar(20))) FROM Service_Details FOR XML PATH('')),1,2,'')

尝试更换选择''，''用SELECT''，''。用逗号后一个空格。

Try replacing SELECT '','' with SELECT '', ''. Give one space after comma.

这篇关于使用sql xml路径时出现问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！