SQL分割Split

create procedure Sql_Split

@column varchar(255)
as
declare @getcolumn varchar(255)
set @getcolumn = 'aa'
create table #temp
(
  splitfield varchar(255)
)
--set @column = 'ddxx,12qw3,dxxd,sdf,ghd,frh'
while(len(@getcolumn)>1)
begin

 set @getcolumn=substring(@column,0,charindex(',',@column,0))
    
 print charindex(',',@column,0)+1
        if(charindex(',',@column,0)+1!=1)
  begin
  set @column=substring(@column,charindex(',',@column,0)+1,len(@column)-len(@getcolumn)-1)
  end
       else
        begin
               set @getcolumn=@column
        end
        --select colunm_name=@getcolumn
        insert #temp(splitfield) values(@getcolumn)
         if(@getcolumn=@column)
       begin
               set @getcolumn=''
        end
      
end
delete from #temp where splitfield=''
select * from #temp
drop table #temp

转载于:https://www.cnblogs.com/noone/archive/2009/09/28/1575419.html