我将使用
XML
SELECt col1, Split.a.value('.', 'VARCHAr(100)') col2FROM (SELECt col1, col2, Cast ('<M>' + Replace(col2, ' ', '</M><M>') + '</M>' AS XML) AS Data FROM Yourtable) AS A CROSS APPLY Data.nodes ('/M') AS Split(a)
我将使用
XML
SELECt col1, Split.a.value('.', 'VARCHAr(100)') col2FROM (SELECt col1, col2, Cast ('<M>' + Replace(col2, ' ', '</M><M>') + '</M>' AS XML) AS Data FROM Yourtable) AS A CROSS APPLY Data.nodes ('/M') AS Split(a)名师互学网 版权所有 (c)2021-2022 ICP备案号：晋ICP备2021003244-6号
