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('.', 'nvarchar(100)') from a.txt.nodes('/root/v') C(v)) b
HISOrderID:需要拆分的字符串字段
T_Order:为表名
#:拆分的字符