Sql server 分割符函式

SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS OFF
GO

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  

GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/16436858/viewspace-553441/，如需轉載，請註明出處，否則將追究法律責任。