2008-06-06
sql 分离字符串 获得数组函数 包括字符串数组的排序
create function GetArrayTable(@SourceSql varchar(8000),@StrSeprate varchar(10))
returns @temp table(element nvarchar(4000),orderNum int)
as
begin
declare @i int
declare @length int
set @length = 0
set @SourceSql=rtrim(ltrim(@SourceSql))
set @i=charindex(@StrSeprate,@SourceSql)
while @i>=1
begin
set @length = @length + 1
insert @temp(element,orderNum) values(left(@SourceSql,@i-1),@length)
set @SourceSql=substring(@SourceSql,@i+1,len(@SourceSql)-@i)
set @i=charindex(@StrSeprate,@SourceSql)
end
if @SourceSql<>''
begin
set @length = @length + 1
insert @temp values(@SourceSql,@length)
end
return
end
评论排行榜