create function func_splitstring(@str nvarchar(max),@split varchar(10))returns @t Table (c1 varchar(100))asbegin declare @i int declare @s int set @i=1 set @s=1 while(@i>0) begin set @i=charindex(@split,@str,@s) if(@i>0) begin insert @t(c1) values(substring(@str,@s,@i-@s)) end else begin insert @t(c1) values(substring(@str,@s,len(@str)-@s+1)) end set @s = @i + 1 end returnend
执行：select * from dbo.func_splitstring('1,2,3,4,5,6', ',')
