SQL Server 字符串分割

SQL Server 2016以后的版本

1 SELECT value
2 FROM STRING_SPLIT('apple,banana,cherry', ',');

SQL Server 2016之前的版本

1 SELECT 
2     Item.a.value('.', 'VARCHAR(100)') AS Item
3 FROM 
4     (SELECT CAST('<M>' + REPLACE([DelimitedData], ',', '</M><M>') + '</M>' AS XML) AS Data
5      FROM (SELECT 'apple,banana,cherry' AS DelimitedData) AS D) AS A
6 CROSS APPLY 
7     Data.nodes('/M') AS Item(a);

 

posted @ 2025-03-17 17:07  陆陆无为而治者  阅读(39)  评论(0)    收藏  举报