将特殊字符创分开后存入表中

IF OBJECT_ID('udf_split', 'tf') IS NOT NULL
    Drop function udf_split
GO
create function udf_split
(
    @str varchar(2000),
    @spl varchar(2)=','
)
returns @table table
(
    id int identity(1,1),
    textstr varchar(200)
)
as
begin
declare @dang int
declare @next int
declare @text varchar(200)
set @dang=1
while @dang<=len(@str)
begin
    set @next=charindex(@spl,@str,@dang)
    if @next=0 or @next is null
    set @next=len(@str)+1
    set @text=substring(@str,@dang,@next-@dang)
    insert into @table values(@text)
    set @dang=@next+1
end
return
end
go

--select * from udf_split('1,2/1,3/1,4/2,6/2,22','/')

select SUBSTRING(textstr, 1,Charindex(',', textstr)-1) as id , SUBSTRING(textstr, Charindex(',', textstr)+1, len(textstr)) as value
from  udf_split('1,2/1,3/1,4/2,6/2,22','/')