sql server 字符串分割函数

create   function   f_splitstr(@SourceSql   varchar(8000),@StrSeprate   varchar(100))   
returns   @temp   table(F1   varchar(100))   
as     
begin   
declare   @ch   as   varchar(100)   
set   @SourceSql=@SourceSql+@StrSeprate     
while(@SourceSql<>'')   
begin   
set   @ch=left(@SourceSql,charindex(',',@SourceSql,1)-1)   
insert   @temp   values(@ch)   
set   @SourceSql=stuff(@SourceSql,1,charindex(',',@SourceSql,1),'')   
end   
return   
end   

测试：

 select   *   from   dbo.f_splitstr('1,2,3,4',',')aa dbo.f_splitstr('1,2,3,4',',') bb