sql 按符号拆分字符串

sql 按符号拆分字符串

单行的数据可以直接用表值函数
Create FUNCTION [dbo].[F_Split](@SplitString nvarchar(max),  --源字符串@Separator nvarchar(10)=' '   --分隔符号，默认为空格)RETURNS @SplitStringsTable TABLE  --输出的数据表([id] int identity(1,1),[value] nvarchar(max))ASBEGINDECLARE @CurrentIndex int;DECLARE @NextIndex int;DECLARE @ReturnText nvarchar(max);SELECT @CurrentIndex=1;WHILE(@CurrentIndex<=len(@SplitString))BEGINSELECT @NextIndex=charindex(@Separator,@SplitString,@CurrentIndex);IF(@NextIndex=0 OR @NextIndex IS NULL)SELECT @NextIndex=len(@SplitString)+1;SELECT @ReturnText=substring(@SplitString,@CurrentIndex,@NextIndex-@CurrentIndex);INSERT INTO @SplitStringsTable([valu