sqlserver如何从带分隔符的字符串创建多个列

如何从带分隔符的字符串创建多个列

4列，你可以这样尝试：

declare @Table table (SomeColumn varchar(100));
insert into @Table
 select 'ball-blue-small-round' union all
 select 'ball-red-small-round' union all
 select 'ball-green-small-round' union all
 select 'ball---square' union all
 select '----';

;with stage (s)
as ( select replace(SomeColumn, '-', '.')
 from @Table
 )
select [item] = parsename(s,4),
 [color] = parsename(s,3),
 [size] = parsename(s,2),
 [shape] = parsename(s,1)
from stage;