sql server 根据特定字符串拆分成多行
Set ARITHABORT ON
select a.*, b.txtId
from (select *, txt=convert(xml, '<root><v>' + replace(HISOrderID, '#', '</v><v>') + '</v></root>')
from T_Order) a
outer apply
(select txtId=C.v.value('.', 'nva.
原创
2021-04-07 16:19:07 ·
929 阅读 ·
0 评论