USE [test]

 GO

 /****** Object:  UserDefinedFunction [dbo].[tf_split_char]    Script Date: 2019/7/8 14:39:15 ******/

 SET ANSI_NULLS ON

 GO

 SET QUOTED_IDENTIFIER ON

 GO

 ALTER FUNCTION [dbo].[tf_split_char]

 (

     @cstring NVARCHAR(MAX), --被拆分的字符串

     @csplit NVARCHAR(1)     --分隔符

 )

 RETURNS @t TABLE

 (

     id INT IDENTITY(1, 1) PRIMARY KEY,

     cchar NVARCHAR(MAX) NOT NULL

 )

 AS

 BEGIN

     DECLARE @ilocation INT = 0;

     DECLARE @inextlocation INT = 1;

     DECLARE @ilen INT;

     WHILE @inextlocation > 0

     BEGIN

         SET @inextlocation = CHARINDEX(@csplit, @cstring, @ilocation + 1);

         SET @ilen = CASE

                         WHEN @inextlocation > 0 THEN

                             @inextlocation

                         ELSE

                             LEN(@cstring) + 1

                     END - @ilocation - 1;

         INSERT INTO @t

         (

             cchar

         )

         VALUES

         (SUBSTRING(@cstring, @ilocation + 1, @ilen));

         SET @ilocation = @inextlocation;

     END;

     RETURN;

 END;