SQL 一列转多行

SELECT ProductNo , ProductCNName , D.[value] AS SelectedProductFROM dbo.TPRODUCT A WITH ( NOLOCK ) LEFT JOIN ( SELECT [value] = CAST('<v>' + REPLACE(product_code, ',', '</v><v>') + '</v>' AS XML) FROM TRULE WITH ( NOLOCK ) ) temp OUTER APPLY ( SELECT [value] = T.C.value('.', 'varchar(50)') FROM temp.[value].nodes('/v') AS T ( C ) ) D ON '''' + A.ProductNo + '''' = D.[value]

原来一列的值

'00306','00031'

 

转换后 两行

'00306''00031'

 

转载于:https://www.cnblogs.com/Amity1006/p/7070077.html

相关资源：SQL SERVER 根据关键字符,将一列分成多行