参考https://www.cnblogs.com/huangshuqiang/p/5477385.html

SELECT

a.A,

a.B,

a.C

FROM

(

SELECT

PARSENAME( REPLACE( a.Content , '.', '.' ), 3 ) AS A,

PARSENAME( REPLACE( a.Content , '.', '.' ), 2 ) AS B,

PARSENAME( REPLACE( a.Content , '.', '.' ), 1 ) AS C 

FROM

test AS a 

WHERE

len( a.content ) - len(

replace( a.content, '.', '' )) = 2 

UNION

SELECT

PARSENAME( REPLACE( a.Content , '.', '.' ), 2 ) AS A,

PARSENAME( REPLACE( a.Content , '.', '.' ), 1 ) AS B,

'' AS C 

FROM

test AS a 

WHERE

len( a.content ) - len(

replace( a.content, '.', '' )) = 1 UNION

SELECT

PARSENAME( REPLACE( a.Content , '.', '.' ), 1 ) AS A,

'' AS B,

'' AS C 

FROM

test AS a 

WHERE

len( a.content ) - len(

replace( a.content, '.', '' )) = 0 

)as a

代码中大写字母ABC分别对应图片中的BCD列数据，A为第一层,B为第二层，C为第三层，ABC通过.间隔