SQL SPLIT() 方法实现

ALTER   function   [dbo].[Fun_Split](@c   varchar(2000),@split   varchar(2)) 
returns   @t   table(col   varchar(20)) 
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