create table #temp
(
id integer identity(1,1),
TName varchar(20)
)
set @sString='收货1->收货2->检查->校对->处理完成'
while len(@sString)>0
begin
set @length=charindex('->',@sString)
if @length>0
begin
insert into #temp (TName) select substring(@sString,1,@length-1)
set @length=@length+2
set @sString= substring(@sString,@length,len(@sString))
end
else
begin
if @length=0
begin
insert into #temp (TName) select @sString
set @sString=''
end
end
end