sql server 根据特定字符串拆分成多行
Set ARITHABORT ONselect a.*, b.txtIdfrom (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 ·
969 阅读 ·
0 评论