SQL中拆分字符串



ALTER   function   [dbo].[my_split](@c   varchar(4000),@split   varchar(2))   
returns   @t   table(id int identity(1,1),col   varchar(500))   
as   
begin       
  while(charindex(@split,@c)<>0)   
    begin   
      insert   @t(col)   values   (substring(@c,1,charindex(@split,@c)-1))   
      set   @c   =   stuff(@c,1,charindex(@split,@c),'')   
    end   
  insert   @t(col)   values   (@c)   
  return   
end