创建 func_splitstring 函数
Create FUNCTION [dbo].[func_splitstring]
(
@str NVARCHAR(MAX) ,
@split VARCHAR(10)
)
RETURNS @t TABLE ( c1 VARCHAR(100) )
AS
BEGIN
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
RETURN
END
调用实例: