SQL 逗号分隔将一行拆成多行

SELECT A.ORF002, B.ORF009 FROM
(
SELECT ORF002, ORF009 = CONVERT (xml, '<root><v>' + REPLACE (ORF009, ',' , '</v><v>' ) + '</v></root>' ) FROM RGWORF
) A OUTER APPLY
(
SELECT ORF009 = N.v.value( '.' , 'varchar(100)' ) FROM A.ORF009.nodes( '/root/v' ) N(v)
) B

ORF009是你要拆分的字段，OPR002