根据，行转列

 PARSENAME(REPLACE(REPLACE(zhiwei, '兼',','),',','.'), 1) AS col1,
    PARSENAME(REPLACE(REPLACE(zhiwei, '兼',','),',','.'), 2) AS col2,
	PARSENAME(REPLACE(REPLACE(zhiwei, '兼',','),',','.'), 3) AS col2

原本数据：

需求：

SELECT
    PARSENAME(REPLACE(REPLACE(zhiwei, '兼',','),',','.'), 1) AS col1,
    PARSENAME(REPLACE(REPLACE(zhiwei, '兼',','),',','.'), 2) AS col2,
	PARSENAME(REPLACE(REPLACE(zhiwei, '兼',','),',','.'), 3) AS col2
from job