自定义sql 的split函数
CREATE FUNCTION dbo.dhg_splitstr ----- 2006-6-21 17:00 过滤函数
(
@SourceSql varchar(8000),
@StrSeprate varchar(10)
)
RETURNS @temp table(A1 int identity(1,1) not null, F1 varchar(100))
AS
BEGIN
declare @i int
set @SourceSql=rtrim(ltrim(@SourceSql))
set @i=charindex(@StrSeprate,@SourceSql)
while @i>=1
begin
insert @temp values(left(@SourceSql,@i-1))
set @SourceSql=subString (@SourceSql,@i+1,len(@SourceSql)-@i)
set @i=charindex(@StrSeprate,@SourceSql)
end
if @SourceSql<>''
insert @temp values(@SourceSql)
RETURN /* value */
END
(
@SourceSql varchar(8000),
@StrSeprate varchar(10)
)
RETURNS @temp table(A1 int identity(1,1) not null, F1 varchar(100))
AS
BEGIN
declare @i int
set @SourceSql=rtrim(ltrim(@SourceSql))
set @i=charindex(@StrSeprate,@SourceSql)
while @i>=1
begin
insert @temp values(left(@SourceSql,@i-1))
set @SourceSql=subString (@SourceSql,@i+1,len(@SourceSql)-@i)
set @i=charindex(@StrSeprate,@SourceSql)
end
if @SourceSql<>''
insert @temp values(@SourceSql)
RETURN /* value */
END