我正在尝试通过使用以下查询将单个逗号分隔的行(列)转换为多行:
SELECT
Split.a.value('.','VARCHAR(max)') AS String
FROM
(SELECT
CAST ('<M>' + REPLACE(cast([csvdata] as Varchar(max)),','</M><M>') + '</M>' AS XML) AS String
FROM
tboutbound
WHERE
id = '30') AS A
CROSS APPLY
String.nodes ('/M') AS Split(a);
但是我得到一个错误:
“ XML解析:第2行,字符36,非法名称字符”
无法更新表格并更改数据吗?
有什么建议吗?