SQLServer分割字符串

 

create function f_split(@s nvarchar(max), @split nvarchar(2))  
　　returns @t table(id int identity(1,1), col nvarchar(32))  
as
begin
  if(len(@s)<1)
  begin
    return
  end
  while(charindex(@split, @s)<>0)  
    begin  
      insert @t(col) values (substring(@s, 1, charindex(@split, @s)-1))  
      set @s = stuff(@s,1,charindex(@split,@s),'')  
    end  
  insert @t(col) values (@s)  
  return
end