sql 拼接字符串xml转行

DECLARE @ids VARCHAR(2200) ='a,c,d,e,f,g'
                                        SELECT  c.value('.','varchar(50)') AS id
                                        FROM    (
                                                 SELECT CAST('<r>'
                                                        + REPLACE(@ids,',',
                                                              '</r><r>')
                                                        + '</r>' AS XML) AS value
                                                ) tb
                                        CROSS APPLY tb.value.nodes('*') t (c)