关于表中列数据拆分为行数据SQL

表名：tb

查询语句：

SELECT a.[name],b.[value] 

FROM (SELECT [name],[value]=CAST(''+REPLACE([value],',','')+'' AS xml) FROM tb )  a

OUTER APPLY (SELECT [value]=T.C.value('.','varchar(50)') FROM a.[value].nodes('/v') AS T(C)) b

更多行与列问题，参考：

https://www.cnblogs.com/no27/p/6398130.html