sql server ×Ô¶¨Òåsplit(·Ö¸î)º¯Êý

ALTER function [dbo].[split]
(
@SourceSql varchar(8000),
@StrSeprate varchar(10)
)
returns @temp table(F1 varchar(100))
as
begin
declare @i int
set @SourceSql = rtrim(ltrim(@SourceSql))
set @i = charindex(@StrSeprate,@SourceSql)
while @i >= 1
begin
if len(left(@SourceSql,@i-1))>0
begin
insert @temp values(left(@SourceSql,@i-1))
end
set @SourceSql=substring(@SourceSql,@i+1,len(@SourceSql)-@i)
set @i=charindex(@StrSeprate,@SourceSql)
end
if @SourceSql <> ''
insert @temp values(@SourceSql)
return
end
----------------------------------------
//Ó¦ÓÃ
--¿ªÊ¼µü´ú·Ö¸î³öÀ´µÄ²ÎÊý
declare @str nvarchar(10)
declare auth_cur cursor for select F1 from split(Òª·Ö¸îµÄ²ÎÊý,'·Ö¸ô·û')
open auth_cur
fetch next from auth_cur into @str
while ( @@fetch_status = 0 )
begin
//×ö´¦Àí
end
close auth_cur
deallocate auth_cur