SQL 字符拆分

if(object_id('func_splitstring') is not null)
     drop function func_splitstring
go
create function func_splitstring(@str varchar(max),@splitstr varchar(10))
returns @tmpdt table (columnid varchar(10))
as
begin
       declare @xquery xml
       set @xquery=convert(xml,'<items><item id="'+replace(@str,@splitstr,'"/><item id="')+'"/></items>')
       insert into @tmpdt select xquery.item.value('@id[1]','varchar(10)') from @xquery.nodes('//items/item') as xquery  (item)
       return
end
go
select * from func_splitstring('dfs,dd,dsd,9,8,s,8,ws',',')
go