SELECT B.id
FROM ( SELECT [value] = CONVERT(XML , '<v>' + REPLACE('1,2,3' , ',' , '</v><v>')
+ '</v>')
) A
OUTER APPLY ( SELECT id = N.v.value('.' , 'varchar(100)')
FROM A.[value].nodes('/v') N ( v )
FROM ( SELECT [value] = CONVERT(XML , '<v>' + REPLACE('1,2,3' , ',' , '</v><v>')
+ '</v>')
) A
OUTER APPLY ( SELECT id = N.v.value('.' , 'varchar(100)')
FROM A.[value].nodes('/v') N ( v )
) B
转载:https://www.cnblogs.com/aierong/archive/2008/11/19/sqlserver_split.html